Level 2
3 words 0 ignored
Ready to learn
Ready to review
Ignore words
Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.
Ignore?
Outer join
Like the inner join but does not require each record from the joined tables to have a matching partner. Missing records are filled with null values.
Left outer join
Contains all records from the left table. If no match is found with the right hand side of the join, the row is filled with null values.
Right outer join
Contains all records from the right table. If no match is found with the left hand side of the join, the row is filled with null values.
