Hi,

I'm newbie with Firebird. Now I try to delete some orphand records using:

DELETE CUEN_DET01.* FROM CUEN_DET01 LEFT JOIN FACTF01 ON (CUEN_DET01.NO_FACTURA = FACTF01.CVE_DOC) AND (CUEN_DET01.CVE_CLIE = FACTF01.CVE_CLPV)
WHERE FACTF01.CVE_DOC Is Null

without a good result.

I'm using IBexpert to do that.

Please help.