sql语句多表联查

select o.order_id,o.order_no,o.totalprice,o.address,
o.telphone,o.contactor,o.createdate,u1.realname as creatorname,
u2.realname as operatorname,u3.realname as sendorname
from t_order o inner join t_user u1 on o.creator=u1.id left join t_user as u2 on o.operator=u2.id left join t_user u3 on 
o.sendor=u3.id