your exists isn't really testing anything
it says... in plain english

delete all records from this table where there exists any record in another
table

there is not logical tie between these two clauses

mine says

delete all records from this table where record ids exist in a list of
record ids described as those with party_id=101010 and etc.


Alan

-----Original Message-----
From: Alexander Tabakov [mailto:saho@...]
Sent: Friday, 21 March 2003 12:28 AM
To: Alan McDonald
Subject: Re[4]: [ib-support] Delete where exists problem

>delete from tbl_service_rel
>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)

That's OK, but I do not understand what is the difference between my delete
statement with "exists" and the one you proposed.

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



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/