[求助] DB2 下的 SQL 如何转换到 MySQL 中运行?
本帖最后由 TaxKiz 于 2015-09-17 23:09 编辑R.T.
有一个 SQL , 在 DB2 中运行没有问题, 但是在 MySQL 中运行, 没有报错, 也没有结果, 表中的数据和结构都是一样的.
请教一下, 该如何修改?SELECT
c.county_name "县区",
substr(recv_time, 1, 6) "月份",
recv_depart_id "收费渠道标识",
b.depart_code "收费渠道编码",
b.depart_name "收费渠道名称",
b.depart_kind_code "收费渠道类型",
recv_staff_id "收费工号",
staff_name "工号名称",
count(*) "收费笔数",
sum(
cast(recv_fee / 100 AS DECIMAL(9, 2))
) "收费金额"
FROM
th_b_paylog_demo a
LEFT JOIN td_p08040_m_depart b ON a.recv_depart_id = b.depart_id
LEFT JOIN td_nc_grp_county c ON b.area_code = c.county_code
LEFT JOIN td_p03001_m_staff d ON a.recv_staff_id = d.staff_id
WHERE
cancel_tag = 0
AND (
(
pay_fee_mode_code = 4
AND charge_source_code = 52
)
OR (
pay_fee_mode_code = 0
AND charge_source_code IN (1, 50)
)
)
AND b.rsvalue2 = '0879'
AND substr(recv_time, 1, 6) = '201507'
AND (
b.depart_kind_code IN (101, 102, 103)
OR b.depart_id IN ('D90CE')
)
GROUP BY
c.county_name,
substr(recv_time, 1, 6),
recv_depart_id,
b.depart_code,
b.depart_name,
b.depart_kind_code,
recv_staff_id,
staff_name 试试写几个最基本查询语句对比试试表结构是否真的相同
页:
[1]