Jump to content


Photo

updating from another table.


  • Please log in to reply
No replies to this topic

#1 Fritz

Fritz
  • Members
  • Pip
  • Newbie
  • 1 posts
  • LocationClearwater, Florida

Posted 03 August 2003 - 03:15 PM

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\';
thanks in advance,
[br]
[br]Fritz Jung
[br]Co-Founder - The Witches\' Voice
[br]http://www.witchvox.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users