At 12:16 PM 23-04-02 +0000, Marco Menardi wrote:

>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.

No, it doesn't. You can only delete rows from one table in a single statement.

>What is the exact syntax?

Delete from table_name
where....

>If is not supported, how can I do?

What exactly are you trying to delete?

H.

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________