Update Statement

["Ng Hwee Hwee" <hhwee@xxxxxxxxxxx>]

hi all,

I would like to do the following:

update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no

however, i found that multiple updates can only work for MySQL version 4.0.4 but mine is 3.23.54... can anyone enlighten me on how I can achieve the same results with this older MySQL version? or can PHP 4.2.2 help me in any way?

Thank you so much!

Hwee