Thanks!! Almost worked, I had to reverse the nest, but that is what I needed .. it will be a huge bear ...stored procedure fer sure!
Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Bartee Lamar" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 12:33 PM Subject: RE: SQL checking query > SELECT f.sub_object, p.title, p.sku > FROM menu_table f, product_table p > WHERE p.id = f.sub_object > OR p.id = f.owner > AND f.type = 'product' > AND f.sub_object NOT IN (select id from product_table) > AND f.owner NOT IN (select id from product_table) > > > Bartee Lamar > www.enterpriseenergy.com > MSN [EMAIL PROTECTED] > > > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 10, 2002 1:02 PM > To: CF-Talk > Subject: OT: SQL checking query > > > Hello folks, > > I have an easy one I am sure... > > I am trying to build a query that will show all items that are not > found...... > > Two tables: > > Product Table > id, title > > Menu Table > id, owner, sub_object > > I want to write a query that will find all product IDs in the product > table, that are not found in either the owner OR the sub_object columns > in the menu table. > > (looking for orphan records, that are not found anywhere in the menu > table). > > Any suggestions, here is what I have so far! > > SELECT f.sub_object, p.title, p.sku > FROM menu_table f, product_table p > WHERE p.id = f.sub_object > OR p.id = f.owner > AND f.type = 'product' > AND f.sub_object NOT IN ('p.id') > AND f.owner NOT IN ('p.id') > > Obviously this query doesn't work .. i have completely mangled it trying > to get the products that cannot be found in the menu. > > Any help is greatly appreciated! > > Paul Giesenhagen > QuillDesign > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
