Re: select query help needed

Daniel, >I have a database with the following (simplified) structure: >[Products] >ProductID >ProductName >[PurchaseRecords] >ProductID >CustomerID > >I need to find all of the rows in the table Products which do not have >at least one corresponding row in PurchaseRecords. How do I transla

select query help needed

Hello All, I have a database with the following (simplified) structure: [Products] ProductID ProductName [PurchaseRecords] ProductID CustomerID I need to find all of the rows in the table Products which do not have at least one corresponding row in PurchaseRecords. How do I translate this