🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.With CROSS JOIN
  2. B.With a SELF JOIN
  3. C.It cannot be done
  4. 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 →