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 vote143 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
3 votes163 views2 answers
Sqlite show table structure
SQL
0 vote142 views1 answer
Check index sql server
SQL
0 vote162 views1 answer
Sql last 3 rows
SQL
0 vote149 views1 answer
Sql count null values in all columns
SQL
2 votes161 views2 answers
How to add not null constraint in sql
SQL
0 vote184 views1 answer
Reset postgresql password windows
SQL
0 vote184 views1 answer
Mysql last friday of current month
SQL
0 vote178 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote147 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL