Domanda di colloquio di Meta
Explain inner and outer join?
Risposta di colloquio
Anonimo
14 gen 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.