请指导我生成sql查询 [英] please Guide me to generate sql Query

问题描述

  Table_Item  
 ----------------------- 
  
 ItemId ItemDescription SalePrice PurchasePrice StockAvailable  
 1饼干半角色20 17 45 
 2筹码30 25 35 
 3 Soap Lux 25 22 40 

  Table_ItemSoldDetail  
 ------ -------------------------- 
  
 ItemId发票#QtySold  
 1 1 1 
 2 2 1 
 1 2 2 
 1 4 1 
 2 5 3 
 3 6 1 

我想从上面两张桌子上显示这个结果

 物品已售出 
 ------------------------- 
 物品描述总销量 
饼干半角色4 
筹码4 
 Soap Lux 1 

请指导我什么是SQL查询来生成th结果????





谢谢

解决方案

< blockquote>尝试：

  SELECT  i.ItemDescriptin，SUM（isd.QtySold） FROM  Table_ItemSoldDetail isd 
  JOIN  Table_Items i 
  ON  i.Id = isd。 ItemId 
  GROUP   BY  isd.ItemId，i.ItemDescription 

列名中的错字--OrignalGriff [/ edit]

Table_Item
-----------------------				

ItemId	ItemDescription	      SalePrice 	PurchasePrice	StockAvailable
1	Biscuit half Role	20                   17        	     45
2 	Lays Chips	        30	             25	             35
3	Soap Lux	        25	             22	             40

Table_ItemSoldDetail
--------------------------------		

ItemId	Invoice#    QtySold
1	   1	      1
2	   2	      1
1	   2	      2
1	   4	      1
2	   5	      3
3	   6	      1

and I want to show this result from above two tables

Item Sold with Count
-------------------------	
Item Description	Total Qty Sold
Biscuit half Role	   4
Lays Chips	           4
Soap Lux	           1

Please guide me what will be SQL query to generate this result ????


Thanks

解决方案

Try:

SELECT i.ItemDescriptin, SUM(isd.QtySold) FROM Table_ItemSoldDetail isd
JOIN Table_Items i
ON i.Id = isd.ItemId
GROUP BY isd.ItemId, i.ItemDescription

[edit]Typo in column name - OrignalGriff[/edit]

这篇关于请指导我生成sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！