How to do a FULL OUTER JOIN in MySQL?

Question

I want to do a Full Outer Join in MySQL. Is this possible? Is a Full Outer Join supported by MySQL?

Answer 1

Hi

You have to use a union with left join/right join queries as mysql does not support full outer joins.

so e.g.

SELECT *

FROM Table_A A

LEFT JOIN Table_B B ON A.id = B.id

UNION

SELECT *

FROM Table_A A

RIGHT JOIN Table_B B ON A.id = B.id

Union removes duplicates, Union All does not

Good luck

- Tyler K