select
xd.ordernum AS 'orderNum',
xd.RufundWay AS 'repayType',
li.GuaranteeWay AS 'assureType',
p_i.personal_name AS 'customName',
p_i.personal_sex AS 'sex',
FLOOR(DATEDIFF(DY, substring(p_i.personal_num,7,4), GETDATE()) / 365.25) AS 'age',
left(li.Domicile_place,CHARINDEX('市', li.Domicile_place)) AS 'hkAddress',
p_i.Personal_maritalstatus AS 'maritalStatus',
li.hangyeleixing AS 'industryNature',
li.income AS 'salary',
p_i.personal_num AS 'idNum',
xd.LoanUse AS 'purpose'
from XDOrder_Table xd
LEFT JOIN dbo.Loan_Info li ON xd.ordernum=li.ordernum
LEFT JOIN dbo.Personal_Info p_i ON xd.UserID=p_i.personal_id
WHERE
xd.ordernum in
<foreach item="orderNum" index="index" collection="list" open="(" separator="," close=")" >
#{orderNum}
</foreach>