Selecting Records Without Corresponding Records?
Posted: Thu Jan 18, 2007 4:55 pm
I have three tables:
tbl_publication
============
pubID
pubName
tbl_subject
================
subjectID
subjectName
tbl_publication_subject
=================
pubsubjID
pubID
subjectID
I don't have foreign keys setup, as I'm using an older version of mYSQL.
Basically, only some of the publications will appear within tbl_publication_subject. What I would like to do is select all those pubIDs from tbl_publication whose pubIDs *do not appear* in tbl_publication_subject. Is this possible? Can somebody help with the SQL? This is what I have so far:
SELECT tbl_publication.pubID, tbl_publication.pubName FROM tbl_publication, tbl_publication_subject WHERE (tbl_publication.pubID != tbl_publication_subject.pubID)
Thanks in advance for your help.
tbl_publication
============
pubID
pubName
tbl_subject
================
subjectID
subjectName
tbl_publication_subject
=================
pubsubjID
pubID
subjectID
I don't have foreign keys setup, as I'm using an older version of mYSQL.
Basically, only some of the publications will appear within tbl_publication_subject. What I would like to do is select all those pubIDs from tbl_publication whose pubIDs *do not appear* in tbl_publication_subject. Is this possible? Can somebody help with the SQL? This is what I have so far:
SELECT tbl_publication.pubID, tbl_publication.pubName FROM tbl_publication, tbl_publication_subject WHERE (tbl_publication.pubID != tbl_publication_subject.pubID)
Thanks in advance for your help.