可以的啊
SELECT ItemName
FROM KKK
INNER JOIN
(
SELECT InvItemID, SUM(Quantity)
FROM MMM
GROUP BY InvItemID
) b ON KKK.InvItemID = b.InvItemID
SELECT ItemName
FROM KKK
INNER JOIN
(
SELECT InvItemID, SUM(Quantity)
FROM MMM
GROUP BY InvItemID
) b ON KKK.InvItemID = b.InvItemID
SELECT ItemName FROM KKK JOIN
(SELECT InvItemID, SUM(Quantity) as Qty FROM MMM GROUP BY InvItemID) b ON KKK.InvItemID = b.InvItemID
FROM KKK
INNER JOIN
(
SELECT InvItemID, SUM(Quantity) item_qty
FROM MMM
GROUP BY InvItemID
) b ON KKK.InvItemID = b.InvItemID
ON KKK.InvItemID = b.InvItemID
--没有为子查询b的第二列指定列名。
加个别名可以了。
(SELECT InvItemID FROM MMM GROUP BY InvItemID) b ON KKK.InvItemID = b.InvItemID
这个SUM(Quantity)不要吧?
(SELECT InvItemID, SUM(Quantity) As NUM FROM MMM GROUP BY InvItemID) b ON KKK.InvItemID = b.InvItemID
(SELECT InvItemID, SUM(Quantity) FROM MMM GROUP BY InvItemID) b ON KKK.InvItemID = b.InvItemID
FROM KKK
JOIN
(SELECT InvItemID as InvItemID, SUM(Quantity) As NUM FROM MMM GROUP BY InvItemID
)
b ON KKK.InvItemID = b.InvItemID
就可以了。