| Subject | Re: [firebird-support] what is it wrong in this query? |
|---|---|
| Author | Dennis McFall |
| Post date | 2008-11-26T15:21:04Z |
At 08:35 AM 11/26/2008, you wrote:
>what is it wrong in this query?./dm
>
>
>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
>.-----------------------------.
>
>You are right: You cannot update joined tables.