select
o.id oid,
o.orderno oorderno,
o.uid uid,
u.name uname,
u.age uage
from orders o left outer join users u on o.uid=u.id where o.id=#{id}
select
o.id ,
o.orderno ,
o.uid ,
u.name ,
u.age
from orders o left outer join users u on o.uid=u.id where o.id=#{id}
其中 o.id 的名字改成oid显示出来固定语法为select xxx from orders o left outer users u on o.uid=u.id where o.id=#{id}