SELECT a.Col1,a.Col2,b.Col2
FROM Table1 a
LEFT JOIN Table2 b
ON a.Col1 = b.Col1
UNION
SELECT b.Col1,a.Col2,b.Col2
FROM Table1 a
RIGHT JOIN Table2 b
ON a.Col1 = b.Col1
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.