← Quiz: SQL Joins: all 10 questions
Quiz: SQL Joins · Question 9 of 10
MySQL has no FULL OUTER JOIN. How is it usually written there?
MySQL has no FULL OUTER JOIN. How is it usually written there?
- A.With CROSS JOIN
- B.With a SELF JOIN
- C.It cannot be done
- D.A LEFT JOIN and a RIGHT JOIN combined with UNION
Answer & explanation
Correct answer: A LEFT JOIN and a RIGHT JOIN combined with UNION
UNION of both one-sided outer joins gives all rows from both sides.
Can you get the rest right without peeking?
Take the timed Quiz: SQL Joins quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →