Re: SQL challenge;-)

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Tue, 8 May 2001 11:45:17 +0100
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740D878FC6@apps.leeds.lfs.co.uk>

Thanks. Another learning experience today :o)

Regards, Norman.

-----Original Message-----
From: Ketan Shah [mailto:shahkn_at_home.com] Posted At: Sunday, May 06, 2001 4:47 AM
Posted To: server
Conversation: SQL challenge;-)
Subject: Re: SQL challenge;-)

select ta.a,ta.b from table_a ta
where (ta.a,ta.b) not exists (select tb.a,tb.b from table_b tb where tb.a =
ta.a and tb.b = tb.b)

PS - 1. not exists will work a lot faster than not in.

2. As others have pointed out, set operator minus will be very fast
also. Received on Tue May 08 2001 - 05:45:17 CDT