没错阿。第二个写法select a, b from a union select a, b from b
你改用union all测试一下
select x,y from a UNION select x,y from B ;
select x,y from a UNION select x,y from B ;
我也觉得奇怪,我的语句比较长,执行单个语句都是OK的,而且我用简单点的语句select x,y from a UNION select x,y from B ; 是没问题的不知道问题出在哪?????????????
我有个语句 select ... '标准件' AS LX ...这种表示不影响UNION连接吧!!!!
SELECT gzb.GZCLR,mkjb.MKJMC,gzb.LX,gzb.JGLX,gzb.CLJG,gzb.DHHM,gzb.YHMC,gzb.LXDH,gzb.GZXX1,gzb.CLRQ,gzb.CLSJ from XXB,MKJB..... union SELECT gzb.GZCLR,'无' AS MKJMC,gzb.LX,gzb.JGLX,gzb.CLJG,gzb.DHHM,gzb.YHMC,gzb.LXDH,gzb.GZXX1,gzb.CLRQ,gzb.CLSJ FROM GZB... 单个语句查询没问题!一用UNION 就提示 ORA-00933:命令未正确结束
单个查没问题,FROM 后面的语句不会有什么影响吧 SELECT gzb.GZCLR,mkjb.mkjmc,gzb.LX,gzb.JGLX,gzb.CLJG,gzb.DHHM,gzb.YHMC,gzb.LXDH,gzb.GZXX1,gzb.CLRQ,gzb.CLSJ FROM GZB,YHXXB,MKJB where yhxxb.SSJB=mkjb.mkjh AND yhxxb.dhhm=gzb.dhhm and gzb.ZT='运行' and (gzb.CLRQ between to_date('2008-10-28 ','yy-mm-dd') and to_date('2008-10-28 ','yy-mm-dd')) and gzb.LX='普通' order by GZCLR,mkjb.mkjmc,gzb.LX,gzb.JGLX UNION SELECT gzb.GZCLR,'无' AS MKJMC,gzb.LX,gzb.JGLX,gzb.CLJG,gzb.DHHM,gzb.YHMC,gzb.LXDH,gzb.GZXX1,gzb.CLRQ,gzb.CLSJ FROM GZB where gzb.ZT='停用' and (gzb.CLRQ between to_date('2008-10-28 ','yy-mm-dd') and to_date('2008-10-28 ','yy-mm-dd')) and gzb.dhhm not in (select dhhm from yhxxb) and gzb.LX='普通' order by GZCLR,gzb.LX,gzb.JGLX
from a
union
select a, b from b
UNION
select x,y from B ;
UNION
select x,y from B ;
UNION
select x,y from B ; 是没问题的不知道问题出在哪?????????????
我有个语句 select ... '标准件' AS LX ...这种表示不影响UNION连接吧!!!!
union
SELECT gzb.GZCLR,'无' AS MKJMC,gzb.LX,gzb.JGLX,gzb.CLJG,gzb.DHHM,gzb.YHMC,gzb.LXDH,gzb.GZXX1,gzb.CLRQ,gzb.CLSJ FROM GZB...
单个语句查询没问题!一用UNION 就提示 ORA-00933:命令未正确结束
单个查没问题,FROM 后面的语句不会有什么影响吧
SELECT gzb.GZCLR,mkjb.mkjmc,gzb.LX,gzb.JGLX,gzb.CLJG,gzb.DHHM,gzb.YHMC,gzb.LXDH,gzb.GZXX1,gzb.CLRQ,gzb.CLSJ FROM GZB,YHXXB,MKJB where yhxxb.SSJB=mkjb.mkjh AND yhxxb.dhhm=gzb.dhhm and gzb.ZT='运行' and (gzb.CLRQ between to_date('2008-10-28 ','yy-mm-dd') and to_date('2008-10-28 ','yy-mm-dd')) and gzb.LX='普通' order by GZCLR,mkjb.mkjmc,gzb.LX,gzb.JGLX
UNION
SELECT gzb.GZCLR,'无' AS MKJMC,gzb.LX,gzb.JGLX,gzb.CLJG,gzb.DHHM,gzb.YHMC,gzb.LXDH,gzb.GZXX1,gzb.CLRQ,gzb.CLSJ FROM GZB where gzb.ZT='停用' and (gzb.CLRQ between to_date('2008-10-28 ','yy-mm-dd') and to_date('2008-10-28 ','yy-mm-dd')) and gzb.dhhm not in (select dhhm from yhxxb) and gzb.LX='普通' order by GZCLR,gzb.LX,gzb.JGLX