select bb.org_name,bb.zhjlbjsl,cc.zhjlgqsl,dd.zhjdbjsl,ee.zhjdgqsl,ff.ptjdbjsl,gg.ptjdgqsl from(
(select o.org_name, count(d.rowid) zhjlbjsl from dc_d_stdbaseinfo d
right join sys_organ o on d.depid=o.org_id
where to_char(d.STDAVAILBDATE,'YYYY')=(select Extract(year from sysdate) from dual)
and (o.org_id=119 or o.parent_id=119) group by o.org_name)bb
full join
(select o.org_name, count(d.rowid) zhjlgqsl from dc_d_stdbaseinfo d
right join sys_organ o on d.depid=o.org_id
where d.STDAVAILBDATE<(select sysdate from dual)
and (o.org_id=119 or o.parent_id=119) group by o.org_name)cc on bb.org_name=cc.org_name ) 这个语句用左连接就没错,改成全连接就运行不过去了,我知道是列明定义的问题,但是我怎么改别名都还报着个错的,请帮忙看看吧~~
(select o.org_name, count(d.rowid) zhjlbjsl from dc_d_stdbaseinfo d
right join sys_organ o on d.depid=o.org_id
where to_char(d.STDAVAILBDATE,'YYYY')=(select Extract(year from sysdate) from dual)
and (o.org_id=119 or o.parent_id=119) group by o.org_name)bb
full join
(select o.org_name, count(d.rowid) zhjlgqsl from dc_d_stdbaseinfo d
right join sys_organ o on d.depid=o.org_id
where d.STDAVAILBDATE<(select sysdate from dual)
and (o.org_id=119 or o.parent_id=119) group by o.org_name)cc on bb.org_name=cc.org_name ) 这个语句用左连接就没错,改成全连接就运行不过去了,我知道是列明定义的问题,但是我怎么改别名都还报着个错的,请帮忙看看吧~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货