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

Raise an ambiguous exception? :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com