MySQL Forums
Forum List  »  Newbie

Update statement with JOIN erroring out
Posted by: Patrick McGovern
Date: August 05, 2005 01:26PM

Thank you in advance to anyone that may be able to shed some light on this.

The syntax looks right here - what am I doing wrong?

UPDATE part_numbers_master JOIN part_numbers
ON part_numbers_master.pn_full=part_numbers.pn_full
SET part_numbers_master.table_id=part_numbers.table_ids;

ERROR 1064: You have an error in your SQL syntax near 'JOIN part_numbers ON part_numbers_master.pn_full=part_numbers.pn_full SET part_n' at line 1

Thanks,
-=Patrick=-

Options: ReplyQuote


Subject
Written By
Posted
Update statement with JOIN erroring out
August 05, 2005 01:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.