- 论坛徽章:
- 9
|
本帖最后由 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
复制代码 |
|