Pregunta de entrevista de Meta
Explain inner and outer join?
Respuesta de la entrevista
Anónimo
14 ene 2020
Inner joins only displays results which satisfies the ON clause in both tables. The Outer or FULL JOIN displays all the results in the tables that satisfy the ON clause, i.e. if a value is displayed in one table but not the other it will display the values in the column that contain values and null values where the data is missing.