+ 1
how to join three table?
i very passionate about programing
1 Resposta
+ 1
Just add another INNER JOIN line after the first one.
https://www.w3schools.com/sql/sql_join_inner.asp
SELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName
FROM ((Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID)
INNER JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID);