I need to delete records from tblshipmentdata_working based on info in LITSO. My code is below:.
The problem is that the query is pulling all the records in tblshipmentdata_working that are in LITOSD for Plant and Code. I want it to only pull records where Plant and Code are equal in the same rows as in LITOSD
DELETE*
FROM tblshipmentdata_working
WHERE (((tblshipmentdata_working.Plant) In (SELECT LITOSD.Plant FROM LITOSD)) AND ((tblshipmentdata_working.Code) In (SELECT LITOSD.Code FROM LITOSD)) AND ((tblshipmentdata_working.Active)=-1));