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