SQL Flashcards
1
Q
What is a full outer join?
A
Joins all rows from both tables and puts nulls in the rows that have no information in the other table.
2
Q
What is a left out join?
A
It takes everything from the left database and adds information from the other table for the rows that are in the left database.
3
Q
What is inner join?
A
It only returns the datasets that overlap.
4
Q
What is a cross join?
A
It is based on cartesian product. For each row in both tables, we will match each row with each row.
