Subject | Re[4]: [ib-support] Delete where exists problem |
---|---|
Author | Alexander Tabakov |
Post date | 2003-03-20T13:28:24Z |
>delete from tbl_service_relThat's OK, but I do not understand what is the difference between my delete
>where tbl_service_rel.id
> in (
> select tbl_service_rel.id from tbl_service_rel rel join tbl_service svc
>on (rel.service_id = svc.service_id)
> where svc.party_id = 10700013277)
statement with "exists" and the one you proposed.
--
Best regards,
Alexander mailto:saho@...