What distinguishes a left join from a union and a right join in SQL?

Question

Anonymous · Accepted Answer

Left join = table on the left has all of it's records kept, even if there was
not a match. Nulls will be in the right table columns when there is no match

Right join = table on the right has all of it's records kept, even if there was
not a match. Nulls will be in the left table columns when there is no match

Union = Stack tables vertically. You need the same column names for both tables.
UNION removes duplicate rows, UNION ALL does not

What distinguishes a left join from a union and a right join in SQL?

Practice this question with AI

Go Premium

Community Answers

Unlock Full Access

Practice More Questions