[Techtalk] SQL query question

Walt pippin at freeshell.org
Wed Apr 30 16:23:31 UTC 2008


At 11:35 PM 4/29/2008, Sara wrote:
>You might find this useful:
>
>http://www.codinghorror.com/blog/archives/000976.html

Thanks for all the info... Especially the diagrams above,
very helpful! However, I'm still not sure any of them do
what I need... I need to select all records in Table A IF
they do not occur in Table B.

I understand that my NOT IN method is extremely
inefficient, but thankfully my data is comparatively small,
and as of yet I know no better way...

Thanks again for the input!
Walt

-~


     A free man is as jealous of his responsibilities as he is of
     his liberties.
                         Cyril James 



More information about the Techtalk mailing list