Compare Sets of Data

D

David127

I have a list of products that have multiple features. Some optional some
manditory. I'd like to compare my table of products and features with a
reference table of products & the manditory features and show the list of
products that are missing the manditory features.

tblProducts tblProductsRef
Prod_ID Prod_ID
Features_ID Features_ID

Many Thanks!!!
 
J

John W. Vinson

I have a list of products that have multiple features. Some optional some
manditory. I'd like to compare my table of products and features with a
reference table of products & the manditory features and show the list of
products that are missing the manditory features.

tblProducts tblProductsRef
Prod_ID Prod_ID
Features_ID Features_ID

Many Thanks!!!
Click to expand...

Use an Unmatched Query Wizard query; or

SELECT tblProjects
RIGHT JOIN tblProductsRef
ON tblProducts.Prod_ID = tblProductsRef.Prod_ID
AND tblProducts.Features_ID = tblProductsRef.Features_ID
WHERE tblProducts.Prod_ID IS NULL;

John W. Vinson [MVP]
 
Top