库存语句

冰娃娃

SELECT  
a.organ as'机构',a.store as '库存部门',a.class as '课别',c.sort as '类别',a.busdate as '进货日期',a.provider as '供应商',a.code as '条码',c.name as '品名',sum(a.amount)as '数量',sum(a.sum_cost)as '成本',成本/数量 as '进价',b.price as '售价' ,b.state as '状态'
       FROM cur_stock a,Commodity c,comm_shop b where a.code =c.code and a.code=b.code and a.organ =b.organ            group by a.organ,a.class,a.code,a.provider,c.sort ,c.name,a.store,b.price ,b.state,a.busdate