Okay, it's taken me about an hour to even be able to form this into a
comprehendible question...
In my REALSQL database, I have two tables, tPersons and tHats.
- The tPersons table has one field: "idNumber" and "personName".
- The tHats table has three fields: "idNumber", "hatColor" and
"ownerIDNumber". The "ownerIDNumber" field references
tPersons.idNumber; its purpose is to indicate which tPerson owns that
particular tHat.
I want to run a query for tPersons that do not own any tHats, and I
can't figure out a way to do it using my noobie SQL knowledge.
I can get the inverse, or complement, of what I want by using this
statement:
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...
***************************************************
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>
