Are you sure you don't want:
select applicationid from applicationdetails where
applicationid not in (select unique applicationid from userdetails)
^^^^^^^^^^^^^^^^^^^^
??
-----Original Message-----
From: robin nayathodan [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 1:54 AM
To: [EMAIL PROTECTED]
Subject: What Happenned to this query (sloging)
Hi All,
Ihave two tables in postgresql each has around 100,000
records and i'm executing this query.
select applicationid from applicationdetails where
applicationid not in (select userid from userdetails)
what is wrong with this query?
Is there any other alternative to get the id which are
not in userdetails
Thanks in advance,
Robin.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
