>delete from tbl_service_rel
>where
> exists(
> select * from tbl_service svc
> where tbl_service_rel.service_id = svc.service_id
> and svc.party_id = 10700013277)
>
>be what you want?

Essentially what you propose is the same query just using SQL89 join
syntax

--
Best regards,
Alexander mailto:saho@...