RE: SQL question ...

Lee How about DELETE FROM A WHERE C1 IN (SELECT C1 FROM B WHERE XXX) AND C2 IN (SELECT C2 FROM B WHERE XXX); Sujit Pal DBA, Computer Sciences Corp. ---------- From: Lin-Chuan Lee[SMTP:lclee@nntp1.best.com] Sent: Tuesday, October 01, 1996 1:15 PM To: informix-list@rmy.emory.edu Subject: SQL question ... Assume I have table A with composite key C1, C2 and table B with composite key C1, C2 . How do I delete from A where C1,C2 in(select C1,C2 from B where XXX) ; Assume C1,C2 may not be chars so no || deals ... also, no cascading deletes ... TIA, -Lin