34,587
社区成员
发帖
与我相关
我的任务
分享
select a.roleId,a.armyId,a.battle,
e.infantry,e.cavalry,e.artillery,
m.reserve,m.reserveMax
from yl_roleadjutant a
left join yl_roleEquip e on a.roleId = e.roleId
left join yl_roleArmy m on a.roleId = m.roleId
where a.id=100;
select a.roleId,a.armyId,a.battle,
e.infantry,e.cavalry,e.artillery,
m.reserve,m.reserveMax
from (select roleId,armyId,battle from yl_roleadjutant where id=100) a
left join yl_roleEquip e on a.roleId = e.roleId
left join yl_roleArmy m on a.roleId = m.roleId;