delete with intersect

[specv]

Hi,

Can we use intersect with delete command (or only with select) like :

delete addrid from emails
where emailhost = 'yahoo.com'
and
addrid in (select addrid from address where city
= 'Seattle')
intersect
delete addrid from emails
where emailhost = 'hotmail.com'
and
addrid in (select addrid from address
where city = 'Seattle');

Thanks.

 

[fluteplr]

Maybe I am misunderstanding, but couldn't you just write

delete addrid from emails
where emailhost in ('yahoo.com','hotmail.com')
and
addrid in (select addrid from address where city
= 'Seattle')

 

[specv]

It is just an example, it's not a real problem, what i want to know is just if it is possible :

Delete
....
from ...
where ...
Intersect
Delete
....
from ...
where ...

thanks

 

[OraCool]

A very easy way to check if it works is to try it on a set work tables.

 

[barbarul2001]

In Oracle you can do this, also:
delete from (select * from emails where emails.addrid=address.addrid
and address.city = 'Seattle'
and emailhost in ('yahoo.com','hotmail.com'))

and the aswer to your question is NO!