problem with update using join

[none]

I do not understand what is wrong with my query:

mysql> update prices,prices_tmp set prices.new_ecampus=prices_tmp.new
where prices.isbn = prices_tmp.isbn;

ERROR 1064: You have an error in your SQL syntax near 'prices_tmp set
prices.new_ecampus=prices_tmp.new where prices.isbn = prices_tmp.' at
line 1
it seems to follow the sample code I have seen:

mysql> UPDATE cds, artists
-> SET cds.title = 'The Funkship Odyssey', artists.Artist = 'George
Clinton'
-> WHERE (artists.artistID = cds.artistID) AND (cds.cdID = '2');
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0

[Bill Karwin]

"none" <dt*******@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I do not understand what is wrong with my query:

mysql> update prices,prices_tmp set prices.new_ecampus=prices_tmp.new
where prices.isbn = prices_tmp.isbn;

What version of MySQL are you using? Multi-table updates were implemented
in MySQL 4.0.4, according to the documentation.

http://dev.mysql.com/doc/refman/4.1/en/update.html

Regards,
Bill K.

[none]

i discovered I am running an older version of mysql