bidirectional outer join sql

Solutions on MaxInterview for bidirectional outer join sql by the best coders in the world

showing results for - "bidirectional outer join sql"
Daniel
10 Oct 2017
1SELECT *
2FROM A LEFT JOIN B ON A.id = B.id
3UNION ALL
4SELECT *
5FROM A RIGHT JOIN B ON A.id = B.id
6WHERE A.id IS NULL
7
similar questions
queries leading to this page
bidirectional outer join sql