Re: SQL question ...
Another solution may be:
I think that is faster, but there isn't a graceful solution in SQL...
DELETE FROM A
WHERE 0 < (SELECT count(*)
FROM B
WHERE A.C1 = B.C1 AND A.C2 = B.C2 AND XXX);
Ciao,
Manel