Codebue Fabio - P-Soft wrote:

> what is it wrong in this query?
>
>
> update ART
> inner JOIN FRNA ON ART.CODICE = FRNA.codice
> SET ART.frn_codice = FRNA.frn_codice
>
> I can't make an update on some field using data from other table in this
> way, isn't it?
>

Firebird won't let you update a join, nor will standard SQL. It's an
extension that a number of servers support, but its ambiguous in some
cases. For example, what happens if you update a join term?

Good luck,

Ann