----
[[:hobby:development:sql:full_outer_join_we:sample|{{ :hobby:development:sql:select:full_outer_join2.png?300 |}}]]
----
<sxh sql>
SELECT *
FROM Table1 T1
	FULL OUTER JOIN Table2 T2 ON T1.IdT2 = T2.IdT2
WHERE T1.IdT2 IS NULL OR T2.IdT2 IS NULL;
</sxh>