MySql FULL OUTER JOIN

-- MySql FULL OUTER JOIN

SELECT * FROM t1
LEFT JOIN t2 ON t1.id = t2.id
UNION ALL
SELECT * FROM t1
RIGHT JOIN t2 ON t1.id = t2.id
WHERE t1.id IS NULL

Source: stackoverflow.com

Full join

All part of the tables both matching portions
and unmatching portions from both tables.

Similar codes

0 vote209 views1 answer
Time in sql server
SQL
1 vote231 views1 answer
How to fetch alternate records from two tables
SQL
10 votes219 views1 answer
Query to find object dependencies in oracle
SQL
0 vote221 views1 answer
Gcloud sql instance list
SQL
1 vote228 views2 answers
Create table if not exist
SQL
0 vote212 views1 answer
Alter table name including schema
SQL
0 vote201 views1 answer
Mysql get 2nd value in comma separated list
SQL
8 votes246 views2 answers
Oracle undo usage
SQL
0 vote224 views1 answer
Restore backup mysql .gz
SQL
0 vote213 views1 answer
Sqlcmd no headers
SQL