左右连接查询

firemail

1. select  (@i:=@i+1) as id, o.order_id as orderId
   
2. from (select @i:=0) as id , v_order o left join v_order_item i on o.order_id = i.order_id
   
3.       left join v_payway p on o.pay_way = p.id
   
4.       left join v_member m on i.item_id = m.id
   
5.       left join v_member_type t on m.type = t.id
   
6.       left join v_order_extra e on o.order_id = e.order_id
   
7. 
   
8. where i.item_type=1

复制代码