sql-server-2005 - 在 sql server 2005 中加入三个表

Question

到目前为止，我已经使用了两个表的连接，但现在我想连接三个表，如下图所示


(来源:microsoft.com)

我试过加入两张 table ，

SELECT O.OrderID,O.CustID,O.OrderTotal,C.Name from Orders
as O inner join Customers as C on O.CustID=C.CustID 

如何加入第三张 table ......任何建议......

Answer 1

你对第三个表做同样的事情:

SELECT O.OrderID,O.CustID,O.OrderTotal,C.Name, OC.OrderAmount
FROM Orders as O 
INNER JOIN Customers as C 
  ON O.CustID=C.CustID 
INNER JOIN OrderItems as OC
  ON O.OrderID=OC.OrderID