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;
where tbl2.record_no = \'7686\';
updating from another table.
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users