SELECT tPersons.* FROM tPersons,tHats WHERE
tHats.ownerIDNumber=tPersons.idNumber
How can I do the opposite of that? In other words, how can I get a
recordSet containing the rows that the above statement does not
return? Thanks in advance...
OK... you want all the data from tPersons where their id is NOT IN
the set of people that have a tHat
the set of people who have tHats is
select ownerIDNumber from tHats
so those that have no tHat is
select * from tPersons where idNumber not in ( select ownerIDNumber
from tHats )
Norman, you rock!
Aaron (who replied off-list) and Math, I see that your solutions also
work, though it's going to take me a little time to wrap my brain
around left outer join. I'm going to go with Norman's solution, since
it seems a lot simpler. It appears that they all give me the same
correct set of records... are there any benefits to using one or the
other?
Thanks to everyone for their immediate and considerate help with this!
***************************************************
Toby W. Rush - [EMAIL PROTECTED]
Instructor of Music Theory
PVA Webmaster & Technical Operations Manager
University of Northern Colorado
"Omnia voluntaria est."
***************************************************
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
