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 vote271 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
-2 votes250 views3 answers
Oracle tablespace usage
SQL
24 votes298 views6 answers
Sql change table name
SQL
0 vote255 views1 answer
How to get table current identity value in sql server
SQL
0 vote255 views1 answer
Mysql add root password
SQL
0 vote294 views1 answer
Gcloud sql list databases
SQL
0 vote258 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
18 votes265 views6 answers
Creating table in MySQL
SQL
0 vote270 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote280 views1 answer
Oracle get current schema
SQL