update from another table Question.

[jung]

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';

[tekky]

LEFT JOIN tbl2 ON tbl.com_no=tbl2.com_no; 
update tbl 
set tbl.record_no='7681' 
where tbl2.record_no = 7686;

I've found that when using numerical values, sometimes mysql doesnt like having quotes.....

may or may not work....