Tag: sum
-
Post Views: 35 sql statement: (SELECT SUM(O_G.GOODS_AMOUNT) as AMOUNT_SUM,SUM(o_g.goods_cost*o_g.goods_number) as cost_sum,sum(o_g.goods_number) as number_sum from ERP_ORDER_GOODS AS O_G left outer join erp_order as o on o_g.order_id = o.order_id left outer join erp_goods as g on g.gid = o_g.goods_id left outer join erp_brand as b on b.brand_id = g.brand_id where (o.add_time between “1389715200” and “1389772885”) and (o.order_status=1 or o.order_status=2)) union all (SELECT…