怎么对UNION ALL后的结果集进行查询
日期：2014-05-18 浏览次数：20776 次
如何对UNION ALL后的结果集进行查询？
这是UNION ALL后的结果集，如果再进行查询？SQL
------解决方案--------------------
- SQL code
SELECT
SUBSTRING(REGDATE,1,4) + '-' + SUBSTRING(REGDATE,5,2) + '-' + SUBSTRING(REGDATE,7,2) as [日期],
SUBSTRING(REGDATE,9,2) + ':' + SUBSTRING(REGDATE,11,2) as [时间],
N'入库指示' as [文件类型],
YYVBELN as [出货单编号],
YYINVNO as [发票编号],
YYEBELN as [PO编号],
REGDATE as [登录日]
from IN_STOCK_HEADER WHERE REGDATE like '%20111212%'
UNION ALL
--出库指示
SELECT
SUBSTRING(REGDATE,1,4) + '-' + SUBSTRING(REGDATE,5,2) + '-' + SUBSTRING(REGDATE,7,2) as [日期],
SUBSTRING(REGDATE,9,2) + ':' + SUBSTRING(REGDATE,11,2) as [时间],
N'出库指示' as [文件类型],
VBELN as [出货单编号],
'' as [发票编号],
'' as [PO编号],
REGDATE as [登录日]
from OUT_STOCK_HEADER
这是UNION ALL后的结果集，如果再进行查询？SQL
------解决方案--------------------
- SQL code
select
*
from
(SELECT
SUBSTRING(REGDATE,1,4) + '-' + SUBSTRING(REGDATE,5,2) + '-' + SUBSTRING(REGDATE,7,2) as [日期],
SUBSTRING(REGDATE,9,2) + ':' + SUBSTRING(REGDATE,11,2) as [时间],
N'入库指示' as [文件类型],
YYVBELN as [出货单编号],
YYINVNO as [发票编号],
YYEBELN as [PO编号],
REGDATE as [登录日]
from IN_STOCK_HEADER WHERE REGDATE like '%20111212%'
UNION ALL
--出库指示
SELECT
SUBSTRING(REGDATE,1,4) + '-' + SUBSTRING(REGDATE,5,2) + '-' + SUBSTRING(REGDATE,7,2) as [日期],
SUBSTRING(REGDATE,9,2) + ':' + SUBSTRING(REGDATE,11,2) as [时间],
N'出库指示' as [文件类型],
VBELN as [出货单编号],
'' as [发票编号],
'' as [PO编号],
REGDATE as [登录日]
from OUT_STOCK_HEADER
)t
where
....
------解决方案--------------------
把你的查询括起来组成派生表
select * from (你的查询语句) as t where ....
as t不能漏掉，派生表需要别名
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
