连表/子查询/计算的sql

看不懂的sql语句

1.select om.*,money,cus.c_type,cus.c_weixin_name,isnull(cus.c_discount,0) c_discount,isnull(om.o_money-om.o_money*cus.c_discount,0) money1,isnull(money*(i_year_point+i_month_potint+i_piece_point),0) money2,isnull((om.o_money-om.o_money*cus.c_discount)-money+money*(i_year_point+i_month_potint+i_piece_point),0) money3 from t_order om left join (select isnull(sum(money),0)money,o_code from(select ((select i_price1 from t_in_item where i_code=ti.i_code and p_id=i.p_id)*i.i_amount)money,o.o_code from t_order o left join t_order_item i on i.o_code=o.o_code left join t_order_item_history h on h.o_code=o.o_code and h.p_id=i.p_id left join t_in ti on ti.i_code=h.i_code )a group by o_code)b on om.o_code=b.o_code left join t_custom cus on om.c_id = cus.c_id left join t_order_item i on i.o_code=om.o_code left join t_order_item_history h on h.o_code=om.o_code and h.p_id=i.p_id left join t_in ti on ti.i_code=h.i_code

2.select om.*,money from t_in om left join (select isnull(sum(money),0)money,i_code from(select((select ii.i_price1 from t_in where i_code = ii.i_code)*ii.i_amount)money,i.i_code from t_in i left join t_in_item ii on i.i_code = ii.i_code)a group by i_code)b on om.i_code=b.i_code

转载于:https://www.cnblogs.com/dong208/p/9761946.html