85579.
SELECT
a.podate,
MID (A.PODATE, 6, 2) m,
b.regionalname,
a.dq,
CASE c.customerName
WHEN '公共基金客户' THEN
'公共基金'
WHEN '异常公司费用结算客户' THEN
'公司'
WHEN '异常个人费用结算客户' THEN
'个人和团队'
WHEN '异常团队费用结算客户' THEN
'个人和团队'
ELSE
''
END,
c.outtype,
b.provincename,
b.name,
a.value
FROM
copy_of_t_center_staffersailbak a
LEFT OUTER JOIN t_center_bankbu_level b ON (a.staffer = b.name)
LEFT OUTER JOIN t_center_out c ON (a.id = c.id)
WHERE
a.podate BETWEEN '${开始时间}'
AND '${结束时间}'
AND c.customererName IN (
'公共基金客户',
'异常公司费用结算客户',
'异常个人费用结算客户',
'异常团队费用结算客户'
)
ORDER BY m
报错，求支援，来天兵天将！{:fange01gif:}
