Re: FW: sql delete join question [124]

Tomchik, Kate wrote: > Can we add this as a new feature request? What's wrong with? DELETE FROM T WHERE PK IN (SELECT PK FROM S)Anyway for those not liking IN or EXISTs a simple extension to MERGE would provide salvation: MERGE INTO T USING S ON T.pk = S.pk WHEN MATCHED THEN DELETE (http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls580.htm) Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab