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

4 votes148 views5 answers
Primary key
SQL
0 vote165 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote154 views1 answer
How to create notes in mysql
SQL
0 vote137 views1 answer
Sql server order by nulls last
SQL
9 votes160 views3 answers
Where clause sql
SQL
3 votes148 views2 answers
Order by postgresql
SQL
0 vote141 views1 answer
Describe in sqlite3
SQL
1 vote142 views1 answer
Show indices in mysql table
SQL
1 vote138 views1 answer
Create procedure with encryption
SQL
2 votes136 views1 answer
Rails execute sql
SQL