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

1 vote209 views1 answer
Postgres set column based on another column
SQL
0 vote206 views1 answer
Postgresql import a database of gzip
SQL
0 vote208 views1 answer
Oracle remove line breaks
SQL
7 votes209 views4 answers
What is my mysql version
SQL
2 votes199 views2 answers
Install sqlalchemy
SQL
0 vote211 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote212 views2 answers
Sql trigger difference between for and after
SQL
0 vote213 views1 answer
Order child below the parent in mysqli
SQL
0 vote210 views1 answer
Will graphql replace sql
SQL
1 vote193 views1 answer
Oracle current sequence value
SQL