Flere tabeller

SELECT O.OrderDate, O.TotalDue, A.AddressLine1, 
       A.AddressLine2, A.City, S.Name
FROM Sales.SalesOrderHeader AS O 
  INNER JOIN Person.Address AS A 
       ON O.BillToAddressID = A.AddressID 
  INNER JOIN Purchasing.ShipMethod AS S 
       ON O.ShipMethodID = S.ShipMethodID;