SQL Server - What conditions must be met to be able to do a third join in a sql select statement
Asked By TommySG SG on 13-Jul-15 12:02 PM
take a look at this example
http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_join
How can I do a third join with it?
Robbe Morris replied to TommySG SG on 13-Jul-15 12:40 PM
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers
INNER JOIN TableB
ON Orders.CustomerID=Customers.CustomerID
ON Customers.CustomerID = TableB.SomeOtherColumn