I'll spare you the back story, except to say this isn't critical - I can
accomplish what I want by hand, without a SQL command, I just want to
understand why I'm getting the results I get.
I have a claims table with about 15K records, but only 8 cLastusers
I have a user table with about 30 users, but only 8 are used in the
system, so I'd like to clear them out.
When I run this:
select name, * from tausers where user_ not in (select clastuser from
CLAIMS)
I would expect to get about 22 names, but get an empty result set.
But when I run this:
select name, * from tausers where user_ in (select clastuser from CLAIMS)
I get the 8 names I expect. Can someone clue me in? Thanks.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
