Compare difference in values of same Column in two different tables

Posted by Kirthiga under Sql Server category on | Points: 40 | Views : 1203
select Column1,Column2
from Table1 a full outer join Table2 b on a.Column1=b.Column2
where a.Column1 is null or b.Column2 is null

Comments or Responses

Login to post response