found the solution :

update tbarcode
set tbarcode.bcqtamov = 0.03700
where tbarcode.bckey__2 IN
(
select tbarcodetesta.btkey__1
from tbarcodetesta
where tbarcodetesta.btcodart = 'P30'
)

by

Maurizio P. ha scritto:

>
> hi ,
> i can't find a solution for my simple query :
> i can easily use the UPDATE command using 1 table ,
> but how do it using more then 1 table ?
>
> ....update table1
> set table1.A1 = 'test'
> where table1.A2 = table2.B2 AND table2.B1 = 'somevalue'
>
> i will search more on internet ...
>
> bye
> Chiacchiera con i tuoi amici in tempo reale!
> http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com
> <http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com>
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.15.24/592 - Release Date: 18/12/2006
>
>

Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com