查询自营店已经上架的商品3月份销售数据

最新推荐文章于 2025-08-11 15:48:15 发布

原创最新推荐文章于 2025-08-11 15:48:15 发布 · 991 阅读

0 ·

CC 4.0 BY-SA版权

MySql 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种使用SQL从多个表中联接并提取供应商及其产品销售数据的方法。该查询涵盖了供应商信息、产品详情及销售统计数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select shop.vendor_code as '供应商编码',
	   shop.shop_name as '供应商名称', 
	   item.bn as '产品编码',
       cat.cat_name as '产品类别',
       item.title as '产品名称',
       order_tmp.num as '销售数量',
       item.cost_price as '结算价格',
       item.pingtaishuima as '结算税率', 
       item.price as '销售价格', 
       item.shangjiashuima as '销售税率'
from `sysitem_item_status` itemStatus 
	left join `sysitem_item` item
		on itemStatus.item_id = item.item_id
	left join `sysshop_shop` shop
		on itemStatus.shop_id = shop.shop_id
	left join `syscategory_cat` cat
		on item.cat_id = cat.cat_id
	left join (
				select item_id, count(item_id) as num from systrade_order
				#where status = 'TRADE_FINISHED'
				group by item_id
			  ) order_tmp
		on itemStatus.item_id = order_tmp.item_id
where itemStatus.approve_status = 'onsale' 
	and shop.shop_self_type = 'self'
	and itemStatus.list_time > 1456761601
	and itemStatus.list_time < 1459439999