Try something like: SELECT tPersons.* FROM tPersons LEFT OUTER JOIN tHats ON tHats.ownerIDNumber=tPersons.idNumber WHERE tHats.ownerIDNumber IS NULL
or SELECT * FROM tPersons WHERE idNumber NOT IN (SELECT tPersons.idNumber FROM tPersons,tHats WHERE tHats.ownerIDNumber=tPersons.idNumber) Math On 10/4/06, Toby Rush <[EMAIL PROTECTED]> wrote:
SELECT tPersons.* FROM tPersons,tHats WHERE tHats.ownerIDNumber=tPersons.idNumber
_______________________________________________ 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>
