SQL中一道题，关于内联的？选什么？为什么？

Question

请指出下列正确的内联结语句:（）(选择2项)
A) SELECT a.CompanyName, b.OrderID
FROM Customers a, Orders b where a.CustomerID = b.CustomerID
B) SELECE a.CompanyName, b.OrderID
FROM Customers a INNER JOIN Orders b WHERE ( a.CustomerID = b.CustomerID )
C) SELECE a.CompanyName, b.OrderID
FROM Customers a FULL OUTER JOIN Orders b ON ( a.CustomerID = b.CustomerID )
D) SELECE a.CompanyName, b.OrderID
FROM Customers a INNER JOIN Orders b ON ( a.CustomerID = b.CustomerID )

Answer 1

A和D

B的连接关键字用错了，是on而不是where
C是全连接，不是内连接

Answer 2

a 和 d

b inner 没有用 on ，写到where了
c 是 full outer join ，不是 内联本回答被网友采纳