dwd.settlement_user_pay_month a
LEFT JOIN dwd.sf_user_pay_month b
ON IF (
INSTR(b.policyno, '_') > 0,
SUBSTRING(
b.policyno,
1,
INSTR(b.policyno, '_') - 1
),
b.policyno
) = a.p_policyno
instr
最新推荐文章于 2024-04-27 09:31:28 发布