有2张表,
Order表里要选出来的是:ID,Amount(数量),Money(金额)
Info表里要选出来的是:GoodPrice(成本)(这张表里也有ID)
然后需要从Order表中取出每个ID对应的商品以及各个商品销售的总的数量和总的金额,
这个我已经写了一条这样的语句:
SELECT GoodsID,DateMonth,SUM(GoodsAmount)AS GoodsAmount,SUM(Money) AS Money FROM GoodsOrder2 WHERE DateMonth like '%" + DateMonth + "%' GROUP BY GoodsID,DateMonth ORDER BY Money
运行结果是OK的,但是现在还要取出Info表里的GoodPrice,我该怎么改上面的那条语句呢?求指导
Order表里要选出来的是:ID,Amount(数量),Money(金额)
Info表里要选出来的是:GoodPrice(成本)(这张表里也有ID)
然后需要从Order表中取出每个ID对应的商品以及各个商品销售的总的数量和总的金额,
这个我已经写了一条这样的语句:
SELECT GoodsID,DateMonth,SUM(GoodsAmount)AS GoodsAmount,SUM(Money) AS Money FROM GoodsOrder2 WHERE DateMonth like '%" + DateMonth + "%' GROUP BY GoodsID,DateMonth ORDER BY Money
运行结果是OK的,但是现在还要取出Info表里的GoodPrice,我该怎么改上面的那条语句呢?求指导
T1.id,T1.amount,T1.Money,T2.GoodPrice
from Order T1,Info T2
where T1.Id = T2.Id
你没给出表结构,不好往下说
(
SELECT GoodsID,DateMonth,SUM(GoodsAmount)AS GoodsAmount,SUM(Money) AS Money FROM GoodsOrder2 WHERE DateMonth like '%" + DateMonth + "%' GROUP BY GoodsID,DateMonth ORDER BY Money
)
select a.*,b.GoodPrice from a inner join b on a.GoodsID = b.id
select a.*.b.GoodPrice from (SELECT GoodsID,DateMonth,SUM(GoodsAmount)AS GoodsAmount,SUM(Money) AS Money FROM GoodsOrder2 WHERE DateMonth like '%" + DateMonth + "%' GROUP BY GoodsID,DateMonth ORDER BY Money) a inner join Info b on a.GoodsID=b.GoodsID