Delete Statement

[Ample]

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 [I]<unknown column operator>[/I]
(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))

[Ample]

What through me off was the first optional keyword "from". Got r done.

DELETE 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)