this query is not wrong and not giving any error i'm ruining this query on w3school http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

open this link and paste the query.

    SELECT c.CustomerName, p.ProductName
    FROM Customers c inner join Orders o on c.CustomerID = o.CustomerID
    JOIN OrderDetails od on od.OrderID = o.OrderID
    JOIN Products p on p.ProductID = od.ProductID;

The update with join syntax is specific for each db

The query you are using is valid for SQLSERVER

UPDATE OrderDetails
SET OrderDetails.ProductID = Orders.CustomerID
FROM Orders
INNER JOIN OrderDetails
ON OrderDetails.OrderID = Orders.OrderID

but not for my MySQL

UPDATE OrderDetails
INNER JOIN OrderDetails
ON OrderDetails.OrderID = Orders.OrderID
SET OrderDetails.ProductID = Orders.CustomerID