Re: SQL question ...

Posted in 1996

Irwin Goldstein — 2 Oct 1996 20:06:30 GMT — source: Informix-list mailing list archive (1991-1998)

Lin-Chuan Lee <lclee@nntp.best.com> wrote in article <52rqks$8h6@nntp1.best.com>... > 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 > delete A where exists (select * from B where B.C1 = A.C1 and B.C2 = A.C2 and XXX) HTH -- Irwin Goldstein Objective Software Systems, Inc.