CREATE OR REPLACE VIEW V_ZPK119_ZF0212 AS
SELECT * FROM
(
(SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD B
WHERE A.DOCID=B.DOCID
)
UNION ALL
(SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD1 D
WHERE A.DOCID=D.DOCID
)
)我把UNION里分开的时候都能查询出来 但是一放到一起 就完蛋 帮我看看
SELECT * FROM
(
(SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD B
WHERE A.DOCID=B.DOCID
)
UNION ALL
(SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD1 D
WHERE A.DOCID=D.DOCID
)
)我把UNION里分开的时候都能查询出来 但是一放到一起 就完蛋 帮我看看
解决方案 »
- 在使用IN的时候遇到类型转换问题,帮忙解决。
- 如何创建default约束
- 求SQL SERVER 2000 函数名
- 关键字 'select' 附近有语法错误
- 建了个作业跨服务器取数,源服务器帐号、密码都写在Sql里面,我总觉得不放心。以前用订阅、发布又出现问题,明明有更新老是侦听不到。
- sql server 中能不能的到服务器的IP??????
- pclint工具怎样设置才能识别EXEC SQL?
- 我现在急需通过存储过程把表里的数据写到串口,请高手指点!
- 求记录的时间与服务器时间差,在线等待,急!!!!
- 求一条SQL语句,在线等。。
- sql多表查询
- 关于SQLSERVER2000安装的问题,急!!!
CREATE OR REPLACE VIEW V_ZPK119_ZF0212 AS
SELECT * FROM
(
(SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD B
WHERE A.DOCID=B.DOCID
)a
UNION ALL
(SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD1 D
WHERE A.DOCID=D.DOCID
)b
)
SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD B
WHERE A.DOCID=B.DOCID
UNION ALL
SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD1 D
WHERE A.DOCID=D.DOCID
SELECT * FROM
(
SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD B
WHERE A.DOCID=B.DOCID
UNION ALL
SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD1 D
WHERE A.DOCID=D.DOCID
) AS T
SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD B
WHERE A.DOCID=B.DOCID
UNION ------ union all ===》 union
SELECT * FROM ZPK0000119_ZF00000212_DOCS A,ZPK0000119_ZF00000212_MD1 D
WHERE A.DOCID=D.DOCID 这样有结果吗?