Man, I KNEW i should have taken out a copyright on my name back in the VB days. <g>
Fred On Wed, Jun 26, 2013 at 2:59 PM, Ted Roche <[email protected]> wrote: > 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 > --- > [excessive quoting removed by server] _______________________________________________ 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/cajcbksrcrqsyz5yx8njguptr1_9d+rw7pjfo1f+gm2rv_m2...@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.
