friends..

i have an error using update in my sql

my query is..


update table1 set table1.par1=table2.par1
where table1.id=table2.id

i got the error that table2 is not defined

but table1 and table2 are in the same database

i am using mysql 3.9 version

can u help?

the syntax you want isunfortunately, you must be on 4.0 to use it

in 3.9 i think your only choice is to do a query, get the table2.par1 value, and use that in a simple update of table1