一、需要执行的SQL
select fgroup.id AS firmGroupId,fgroup.firmName,ftype.firmTypeName
from org_firm_group fgroup
LEFT JOIN org_firm_type ftype ON ftype.id=fgroup.firmTypeId
WHERE fgroup.id in(1289,1423,1386,1353)
二、接收的Mapper
一、需要执行的SQL
select fgroup.id AS firmGroupId,fgroup.firmName,ftype.firmTypeName
from org_firm_group fgroup
LEFT JOIN org_firm_type ftype ON ftype.id=fgroup.firmTypeId
WHERE fgroup.id in(1289,1423,1386,1353)
二、接收的Mapper