SQL Flashcards
1
Q
What is default join in BQ sql
A
INNER JOIN
2
Q
What is
INNER JOIN
A
Returns only the rows where there is a match in both tables.
3
Q
LEFT/RIGHT JOIN
A
Returns all rows from the left/right table and the matching rows from the right table. If there’s no match in the left/right table, it returns NULL for the columns of the right table.
4
Q
FULL OUTER JOIN
A
Returns all rows when there is a match in either the left or right table. If there is no match in one of the tables, it returns NULL for the columns of the other table.
5
Q
CROSS JOIN
A
Returns the Cartesian product of the two tables. Each row from the first table is combined with each row from the second table. It does not require an ON clause.
