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