select sales.CommodityID, commodity.CommodityName,commodity.Price,sum(sales.SalesCount) as SummaryCount,(commodity.Price*sum(sales.SalesCount)) as SumPrice from commodity as a,sales as b where datediff('d',sales.SalesDate,now())=0 and sales.CommodityID=commodity.Id GROUP by sales.CommodityID错误信息:至少一个参数没有被指定值。我要查询当天所有相同ID的商品!
a.CommodityName,
a.Price,
sum(b.SalesCount) as SummaryCount,
(a.Price * sum(b.SalesCount)) as SumPrice
from commodity as a inner join sales as b
on a.CommodityID == b.CommodityID
where datediff('d', b.SalesDate, now()) = 0 and
b.CommodityID = a.Id
group by b.CommodityID, a.CommodityName, a.Price
select
sales.CommodityID,
max(commodity.CommodityName),
max(commodity.Price),
sum(sales.SalesCount) as SummaryCount,
(max(commodity.Price)*sum(sales.SalesCount)) as SumPrice
from commodity
as a,
sales as b
where datediff('d',sales.SalesDate,now())=0
and
sales.CommodityID=commodity.Id
GROUP by sales.CommodityID