I need to turn this select statement into a delete statemen. In other words, I want the results of the select statement deleted from the tables. I have never used a delete statement with a minus command. Can anyone help.
SELECT item, ispecyr from itemlist where ispecyr = 79
minus
select b.piitem, a.cpspecyr from
contproj a, projitem b
where a.pcn = b.pcn
and cpspecyr = 79
Thanks.