SELECT TOP 10 T2.*,T3.TypeName FROM Orders T1 JOIN Goods T2 ON T1.GoodsId=T2.GoodsId JOIN GoodsType T3 ON T2.TypeId=T3.TypeId ORDER BY T1.OrderDate DESC把这里面的换成你要的行数
不需要关联 GoodsType,没有用到。
select t2.GoodsName as '商品名称',t2.Price as '单价',sum(t1.SaleCounts) as '销售数量' from Orders t1,Goods t2 where t1.GoodsId=t2.GoodsId group by t2.GoodsName,t2.Price order by t1.OrderDate desc
JOIN Goods T2 ON T1.GoodsId=T2.GoodsId
JOIN GoodsType T3 ON T2.TypeId=T3.TypeId
ORDER BY T1.OrderDate DESC把这里面的换成你要的行数
from Orders t1,Goods t2
where t1.GoodsId=t2.GoodsId
group by t2.GoodsName,t2.Price
order by t1.OrderDate desc