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 into a working MySQL select statement? Many Thanks, Dan Lamb -- --------------------------------------------------------------- Daniel B. Lamb The Breneman Group, LLC "Consulting, Engineering, Innovation" Website: www.TheBrenemanGroup.com E-Mail: [EMAIL PROTECTED] Office: 513-221-1934 Fax: 888-532-6093 Mobile: 810-691-8956 --------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
