有订单表Orders、客户表Custome,显示上海地区所有客户的详细信息,正确的SQL是()
A.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o right join Customer c on o.ID=c.CustomerID where c.address='上海'
B.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o join Customer c where c.address='上海' on o.ID=c.CustomerID
C.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o inner join Customer c on o.ID=c.CustomerID and c.address='上海'
D.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o where c.Address='上海' join Customer c on o.ID=c.CustomerID