Connecting Tech Pros Worldwide Forums | Help | Site Map

Turning this select statement into a delete statement

Newbie
 
Join Date: Mar 2007
Posts: 1
#1: Mar 29 '07
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.

Reply