RE: OT: SQL checking query

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!

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

Re: OT: SQL checking query

Nested select statement. 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 x.ID from theTable WHERE ...) Definately have