updating from another table.

[Fritz]

I am trying to update a field from another table... and I can\'t seem to get the mysql syntax right...

 

com_no is my key field

record_no is the field I am trying to update

 

(I am trying this in phpmyadmin)

 

 

LEFT JOIN tbl2 ON tbl.com_no=tbl2.com_no;

 

update tbl

set tbl.record_no=\'7681\'

where tbl2.record_no = \'7686\';