34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT OrderID
FROM ORDERS
WHERE OrderDate BETWEEN '1998-01-01' AND '1998-01-07'
UNION
SELECT OrderID
FROM ORDERS
WHERE ShippedDate BETWEEN '1998-01-01' AND '1998-01-07'
SELECT OrderID
FROM ORDERS
WHERE OrderDate = '1998-01-01'
OR ShippedDate = '1998-01-01'
SELECT o.OrderID FROM Orders o
JOIN dbo.Customers c ON c.CustomerID=o.CustomerID
SELECT o.OrderID FROM Orders o
JOIN dbo.Customers c ON c.CustomerID=o.CustomerID
WHERE c.City='london'