这里为什么会报错

select a.zch, a.zwc, b.q_ch,b.q_wc,c.c_ch,c.c_wc from

(select sum(nvl(ch_pf_drxs,0)) zch ,sum(nvl(wc_drdh,0)) zwc from yc.busmon_orc where daily_date >= '${tjdate1}' and daily_date <='${tjdate}' and type not in ('Y04'))a, --总

(select sum(nvl(ch_pf_drxs,0)) q_ch,sum(nvl(wc_drdh,0)) q_wc from yc.busmon_orc where daily_date >= '${tjdate1}' and daily_date <='${tjdate}' and type = 'Y01')b,

(select sum(nvl(ch_pf_drxs,0)) c_ch,sum(nvl(c.wc_drdh,0)) c_wc from yc.busmon_orc where daily_date >= '${tjdate1}' and daily_date <='${tjdate}' and type = 'Y03')c

FineReport 用户x076327 发布于 2022-7-22 09:34

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

用户6NWif5139660Lv6资深互助
发布于2022-7-22 09:36（编辑于 2022-7-22 09:37）

子查询别名后面没加空格吧

select a.zch, a.zwc, b.q_ch,b.q_wc,c.c_ch,c.c_wc from

(select sum(nvl(ch_pf_drxs,0)) zch ,sum(nvl(wc_drdh,0)) zwc from yc.busmon_orc where daily_date >= '${tjdate1}' and daily_date <='${tjdate}' and type not in ('Y04')) a, --总

(select sum(nvl(ch_pf_drxs,0)) q_ch,sum(nvl(wc_drdh,0)) q_wc from yc.busmon_orc where daily_date >= '${tjdate1}' and daily_date <='${tjdate}' and type = 'Y01') b,

(select sum(nvl(ch_pf_drxs,0)) c_ch,sum(nvl(c.wc_drdh,0)) c_wc from yc.busmon_orc where daily_date >= '${tjdate1}' and daily_date <='${tjdate}' and type = 'Y03') c