selectdsl_pro_id as defds123quot;商品号defds123quot;,pro_name as defds123quot;品名defds123quot;,pro_spec as defds123quot;规格defds123quot;,pro_unit as defds123quot;单位defds123quot;,br_name as defds123quot;机构名称defds123quot;,dsl_date as defds123quot;销售日期defds123quot;, sum(dsl_sale_qty) as defds123quot;销售数量defds123quot;,sum(dsl_unit_cost) as defds123quot;成本额defds123quot;,sum(dsLsale_amt) as defds123quot;销售金额defds123quot;from pos.product,pos.branch,pos.daily_sale_listwherepro_id=defds123#39;120070defds123#39;and pro_id=dsl_pro_idand dsl_br_id=br_idand dsl_datedefds123gt;=defds123#39;2013-1-01defds123#39;and dsl_datedefds123lt;=defds123#39;2013-1-10defds123#39;group by dsl_pro_id,pro_name,pro_spec,pro_unit,br_name,dsl_dateorder by dsl_pro_id,dsl_date,br_name;
|
