Comments on: Things I didn’t know I hate about MS SQL Server 2000 http://jrwren.wrenfam.com/blog/2005/08/26/things-i-didnt-know-i-hate-about-ms-sql-server-2000/ babblings of a computer loving fool Mon, 21 Nov 2016 19:37:12 +0000 hourly 1 https://wordpress.org/?v=4.7.2 By: Robert Treat http://jrwren.wrenfam.com/blog/2005/08/26/things-i-didnt-know-i-hate-about-ms-sql-server-2000/comment-page-1/#comment-91 Tue, 30 Aug 2005 17:19:58 +0000 http://little.xmtp.net/blog/?p=484#comment-91 select
col1, col2
from
tab1
left join tab2 using (col1,col2)
where
tab2.col1 is null
and
tab2.col2 is null;

]]>