Re: SQL question ...
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)
> ...
How about this:
delete from A where exists
(select C1 from B where B.C1=A.C1 and B.C2=A.C2 where XXX);
----------------------------------------------------------------------
John H. Frantz Power-4gl: Extending Informix-4gl
frantz@centrum.is http://www.strengur.is/~frantz/pow4gl.html