http://blogs.technet.com/b/seanearp/archive/2006/12/14/comparing-column-values-in-t-sql.aspxOkay… so here's the scenario. I have two different tables in a SQL Database, where I need to compare both tables, and find all values in Table B that do not exist in Table A. There are two ways to do this. One with a JOIN, and one with a "NOT EXISTS"en-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/seanearp/archive/2006/12/14/comparing-column-values-in-t-sql.aspx#2476942Fri, 16 Nov 2007 21:20:41 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2476942Chuckster<p>Excellent !!</p> <p>I've been wracking my brains for ages trying to figure out how to do this (new to SQL). I actually have to work out what does not exist in one table when compared to 2 others, but taking the above and allowing for the extra table has solved my problem.</p> <p>I had played around with LEFT OUTER JOIN, but did not consider the comparison with NULL !!</p> <p>Many thanks.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=2476942" width="1" height="1">