I need MySQL query help (again). I am relatively new to SQL querying so here is my dilemma. I had a similiar problem, refer to <A HREF=http://www.phpbuilder.com/board/archive/index.php/"http://phpbuilder.net/forum/archives/5/2001/07/2/15189">my other problem.</A>
I have 2 tables P2CLookup and Descriptions. P2CLookup has a product id and a category name. Descriptions has a product id and a description.
I want to formulate a query where it will retrieve all records that do not have a product id in P2CLookup nor in Descriptions. I have tried using left join but only returns NULL. I have 138 records in Descriptions but only 137 records in P2CLookup. I need to find out what product id is not in Descriptions. Any help would be greatly appreciated since I am struggling with advanced SQL concepts.
I have 2 tables P2CLookup and Descriptions. P2CLookup has a product id and a category name. Descriptions has a product id and a description.
I want to formulate a query where it will retrieve all records that do not have a product id in P2CLookup nor in Descriptions. I have tried using left join but only returns NULL. I have 138 records in Descriptions but only 137 records in P2CLookup. I need to find out what product id is not in Descriptions. Any help would be greatly appreciated since I am struggling with advanced SQL concepts.