Hi, I'm trying to delete from a table using criterion from a join, I mean, some fields value is taken from other tables, so I need a join like:
DELETE FROM PROGRESSIVI_CONTABILI
INNER JOIN PROGRESSIVI_CONTABILI ON (UNITA_IMMOBILIARI.CONDOMINIO_ID = PROGRESSIVI_CONTABILI.CONDOMINIO_ID)
INNER JOIN UNITA_IMMOBILIARI ON (UNITA_U_CLIENTI.UNITAIMM_ID = UNITA_IMMOBILIARI.UNITAIMM_ID)
INNER JOIN UNITA_U_CLIENTI ON (PROGRESSIVI_CONTABILI.ESERCIZIO_ID = UNITA_U_CLIENTI.ESERCIZIO_ID)
WHERE (CONDOMINIO_ID=UNITA_IMMOBILIARI.CONDOMINIO_ID) AND
(ESERCIZIO_ID=OLD.ESERCIZIO_ID) AND
(CONTO_ID=OLD.UICC_ID);

but when I try to compile this trigger I get the error:
Precompiler Error: parsing error - INNER.
Seems that delete and inner join does not work.
What is the exact syntax?
If is not supported, how can I do?
Thanks
Marco Menardi