We're trying to delete "all items in the database that don't have a UPC associated with them". Our primary key is "item#" and the tables are PUB.item and PUB.upc. items are in the item table, and upcs are in the upc table. each UPC has an item number associated to it in the "item#" field.
I can look at the items and UPCs with this query:
SELECT PUB.item."item#",PUB.item.descrpt,PUB.UPC."upc#"
FROM PUB.item
LEFT OUTER JOIN PUB.UPC on PUB.UPC."item#" = PUB.item."item#"
However I cannot seem to turn that query into a "delete all records with a blank "upc#" query.
Help!?
I can look at the items and UPCs with this query:
SELECT PUB.item."item#",PUB.item.descrpt,PUB.UPC."upc#"
FROM PUB.item
LEFT OUTER JOIN PUB.UPC on PUB.UPC."item#" = PUB.item."item#"
However I cannot seem to turn that query into a "delete all records with a blank "upc#" query.
Help!?