当三个表联接的时候,同时用到left join 和inner join,但我下面的sql不对
具体想达到的目的是这样,前面二个表联接之后的结果,再与第三个表联
select a.*,c.username,c.realname from tel_note a left join orders b inner join users c on a.order_id=b.order_number and a.user_id=c.id
具体想达到的目的是这样,前面二个表联接之后的结果,再与第三个表联
select a.*,c.username,c.realname from tel_note a left join orders b inner join users c on a.order_id=b.order_number and a.user_id=c.id
on a.order_id=b.order_number
inner join users c on a.user_id=c.id
from (tel_note a left join orders b on a.order_id=b.order_number )
inner join users c on a.user_id=c.id