I need a delete statement to delete records using the below select statement. I got a mind block as to what should be used in the where clause column operator.
-
DELETE from InvOnHand
-
WHERE <unknown column operator>
-
(SELECT InvOnHand.*
-
FROM InvMaster Join InvOnHand On InvMaster.partno = InvOnHand.partno
-
WHERE InvMaster.category = 'bag' and DatePart(yyyy, transdate) between 2004 and 2007 and NOT (InvOnHand.partno in (partlist))
-
-
SELECT InvOnHand.*
-
FROM InvMaster Join InvOnHand On InvMaster.partno = InvOnHand.partno
-
WHERE InvMaster.category = 'bag' and DatePart(yyyy, transdate) between 2004 and 2007 and NOT (InvOnHand.partno in (partlist))
-
