> -----Original Message-----
> From: André Poisson [mailto:a_poisson@...]
> Sent: Viernes 20 de Abril de 2001 23:01
>
> Using IB_WISQL.
>
> UPDATE FACTURE INNER JOIN CLIENTS ON FACTURE.NoTelephone =
> CLIENT.NoTelephone SET FACTURE.NoClient = Client.NoClient;

Download the IB documentation and read LangRef. This is not valid syntax.
You can't make a JOIN in an UPDATE. You either write a more complex SQL
sentence or a stored procedure (it will be faster).

C.