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 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}
转载于:https://www.cnblogs.com/hbigdata/p/10878433.html