Joining 2 Tables

  • Thread starter Thread starter Dar
  • Start date Start date
D

Dar

I have 2 tables in Access 2000. One holds a list of all
Catalog numbers and the other links those catalog numbers
with their associated Asset numbers.

I want to run a query to find out which catalog numbers
DON'T have any Assets associated with them. Below is my
code:

SELECT tblCatalogMaster.CatalogNum

FROM tblCatalogMaster

WHERE tblCatalogMaster.CatalogNum NOT IN (SELECT
tblAssetCatLink.CatalogNum FROM tblAssetCatLink);


The query keeps freezing up on me. Please help!!!!!


Thanks,

Dar
 
You might try a query whose SQL looks something like this:

SELECT tblCatalogMaster.CatalogNum
FROM tblCatalogMaster
LEFT JOIN tblAssetCatLink
ON tblCatalogMaster.CatalogNum = tblAssetCatLink.CatalogNum
WHERE tblAssetCatLink.CatalogNum IS NULL
 
Back
Top