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