I have two tables "Products" and "Descriptions". "Products" contains a unique Product ID (PID) and other Product Information. "Descriptions" contains the unique product ID and also a description. The description corresponds to the unique product ID. I can't formulate a query where I can SELECT all records in "Products" that DO NOT have a corresponding description in "Descriptions". The best I could come up with is
//
SELECT Products.PID FROM Products, Descriptions WHERE Products.PID != Descriptions.PID
//
But this just returns all the rows in both tables multiplied together that do not have a Description...Arggghh this is frustrating.
If anyone could post a working query to solve this problem it would be greatly appreciated.
//
SELECT Products.PID FROM Products, Descriptions WHERE Products.PID != Descriptions.PID
//
But this just returns all the rows in both tables multiplied together that do not have a Description...Arggghh this is frustrating.
If anyone could post a working query to solve this problem it would be greatly appreciated.