+ 1

how to join three table?

i very passionate about programing

2nd Apr 2019, 6:46 PM
Goutam Yadav
Goutam Yadav - avatar
1 Answer
+ 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);
2nd Apr 2019, 8:00 PM
sneeze
sneeze - avatar