我有带表标题的表
职员
staffID staffName staffAge
产品
productID productDescription productCost
命令
orderID customerID orderDate orderLocation
orderServedby
orderID staffID servedBy
orderSummary
orderID customerID productID summaryOfOrder
我想从列中获取信息staffID，productID并orderLocation取决于谁servedBy在日期（orderDate）之间提供了订单（）
到目前为止我有这个...
SELECT
staff.staffID,
order.orderLocation, orderSummary.productID
FROM
staff
INNER JOIN
orderServedby ON staff.staffID = orderServedby.staffID
INNER JOIN
ordersummary ON product.ProductID = orderSummary.productID
WHERE
OrderDate BETWEEN #07/04/1996# AND #07/09/1996#;
我不确定如何将它们链接在一起，因为它们都依赖于orderID以获得正确的列？抱歉，我是SQL的新手。谢谢
这应该使您开始：
SELECT
staff.staffID,
order.orderLocation,
orderSummary.productID
from Order
inner join orderServedBy on orderServedBy.OrderId = Order.OrderId
inner join orderSummary on orderSummary.OrderId = Order.OrderId
where OrderDate BETWEEN #07/04/1996# AND #07/09/1996#
and ServedBy = '<some value here>'
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句