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 vote378 views1 answer
Apt install sql server
SQL
0 vote374 views1 answer
Manage Database in MySQL
SQL
12 votes322 views1 answer
How to change the value of a table in sql
SQL
5 votes356 views2 answers
Get number of columns sql
SQL
0 vote409 views1 answer
Delete ids between sql
SQL
0 vote395 views1 answer
Wordpress make wp user in db
SQL
2 votes374 views2 answers
Create table mysql integer NOT null
SQL
0 vote337 views1 answer
Get foreign table names mysql
SQL
0 vote355 views1 answer
Sql server information_schema temp tables
SQL
-2 votes347 views1 answer
No module named '_sqlite3
SQL