34,838
社区成员




select a.receiveNO, a.nameCn 姓名, a.IDNO 证件号, a.ScanDate 扫描时间, a.UARLSOURCE 推荐代码,
a.Company 单位名称, a.R_VerifyCode 已核实内容, a.R_RecommenMemo 外部核实,
case a.PostADDR when '1' then a.ADDR1 when '2' then a.CPY_ADDR1 end as ADDR1,
case a.PostADDR when '1' then a.ADDR2 when '2' then a.CPY_ADDR2 end as ADDR2,
b.ApproveAccounts 账号, b.ApproveDT_User 审批时间, b.ReceiveNo 存档号,
c.ReceiveNo, c.RiskInfo 风险电征信息, c.AP_PeopleBank 人行信息分类
from dbo.INApply_BaseInfo as a
join dbo.INApply_ExteriorInfo as b
on a.receiveNO = b.receiveNO and
a.receiveNO in (" + strRecNo + ")
join dbo.INApply_FlagInfo as c
on a.receiveNO = c.receiveNO