Update w/ join not working

[Keith Handlon]

I can not figure out why my update will not work. Can any one help me?

I am trying to update a column in one table with a column from another table. Here are the 2 statements I am using and the returned error. I am using mysqlcc if that makes any difference.

update xcart_products inner join xcart_images on xcart_products.productid = xcart_images.productid set xcart_products.alt = xcart_images.alt

ERROR 1064: You have an error in your SQL syntax near 'inner join xcart_images on xcart_products.productid = xcart_images.productid set' at line 1

update xcart_products, xcart_images set xcart_products.alt = xcart_images.alt where xcart_products.productid = xcart_images.productid

ERROR 1064: You have an error in your SQL syntax near ' xcart_images set xcart_products.alt = xcart_images.alt where xcart_products.p' at line 1