Query of records that are not part of the join

[samiuweb]

Hi,
I have a database with one main table (Projects) and 3 other tables (Students, Organizations, Professors) linked to the main one through many-to-many relationships (through linking tables that is). Basically, the organization I work with does research projects, and each project could have many students (profs and organizations) associated with it, just as each student (prof or organization) could be associated with many separate projects.

Now, I need to develop a query that shows me only those organizations who are NOT linked to projects. I can easily figure out the opposite (organizations who are linked to projects) but I can't seem to do the former. Any ideas?

 

[Jon K]

SELECT Organizations.*
FROM Organizations LEFT JOIN ProjectOrganizationLinkingTable ON [Organizations].[OrganizationID]=[ProjectOrganizationLinkingTable].[OrganizationID]
WHERE [ProjectOrganizationLinkingTable].[OrganizationID] Is Null;


You can also get a similar query using the Find Unmatched Query Wizard.
.

 

[samiuweb]

thanks, worked like a charm!