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.