UPDATE product SET price = 12.95 FROM product INNER JOIN ... MySQL doesn' t like the FROM portion, and I'm not sure that the INNER ...
stackoverflow.com