How can I do a FULL JOIN of MULTIPLE TABLES in MySQL

we have been searching for it but all we see is 2 table开发者_开发知识库s by the left and right inner/outer joins.

I love you guys.

---

MySQL doesn't support FULL OUTER JOIN.

As you mention, you can simulate a FULL OUTER JOIN of two tables using a combination of LEFT and RIGHT OUTER joins.

SELECT * FROM tableA LEFT JOIN tableB ON tableA.b_id = tableB.id
UNION ALL
SELECT * FROM tableA RIGHT JOIN tableB ON tableA.b_id = tableB.id
WHERE tableA.b_id IS NULL

The same technique can in theory be extended to more than two tables. I'd suggest first using the above approach to join two of the tables as a view. Then use the same approach again to join the view to the third table.

---

I don't know what to say about the love part, but

Having tables named a and b:

SELECT a.*, b.* FROM a, b

Does this the trick?