NULL can be thought of the same as the value "I don't know."
select * from users where users in (select usernames from other table) matches one to the other select * from users where users NOT IN (select usernames..) asks "Is User Fred NOT IN a list that includes a value of I Don't Know?" --> what's the answer? I DON'T KNOW. Fred might be in the list, and he might not. Does Fred == NULL? I Don't Know. On Wed, Jun 26, 2013 at 4:27 PM, Vincent Teachout <[email protected]>wrote: > Ted Roche wrote: > >> Any chance the cLastUser can be NULL? >> >> Try: >> >> select name, * from tausers where user_ not in (select clastuser from >> CLAIMS WHERE clastuser IS NOT NULL ) >> > > > Bingo, we have a winner! But why? and why does it work with the IN, but > not the NOT IN? > > > > ______________________________**_________________ > Post Messages to: [email protected] > Subscription Maintenance: > http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox> > OT-free version of this list: http://mail.leafe.com/mailman/** > listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech> > Searchable Archive: > http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox> > This message: http://leafe.com/archives/**byMID/profox/51CB4EA7.9090702@** > taconic.net<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. > > Report [OT] Abuse: http://leafe.com/reportAbuse/** > [email protected]<http://leafe.com/reportAbuse/[email protected]> > -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/cacw6n4seo7ffe1_orcxawkctumh0c9dn6+zujzn4ufjo6p0...@mail.gmail.com ** 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.
