UPDATE ART
SER FRN_CODICE = (SELECT FRN_CODICE FROM FRNA WHERE FRNA.CODICE =
ART.CODICE)

is that what you want?

Marcin


Codebue Fabio - P-Soft pisze:

> 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?
>
>
> fab10
> .-----------------------------.
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>