Joining 2 Tables

[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

 

[Brian Camire]

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