Re: SQL question ...

Posted in 1996

Stefan Weideneder — Wed, 02 Oct 1996 19:58:41 +0100 — source: Informix-list mailing list archive (1991-1998)

> > Lin-Chuan Lee wrote: > > > > 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 > > --------------------------------------------------------------- Bullshit, the result of Netscape's attachment. I'll try it again.