union为什么不能这们用.. (急,在线等)

[anndey]

SELECT DISTINCT [testLoa] AS mname, [tb1] AS nkey, ' ' AS nkey1,' ' AS ft FROM viwPoint
union
SELECT DISTINCT [toor] AS mname, [wsk] AS nkey, testCity AS nkey1,' ' AS ft FROM viwPoint
UNION
SELECT DISTINCT [fpID] AS mname, [www] AS nkey, testLoa AS nkey1,ft FROM viwPoint


---在查询分析器中可以执行,但是不能保存为视图.帮忙一下.

大侠何在,救命呀,

[点点星灯]

各字段的数据类型一致吗？

[duanduan1122]

使用 UNION 组合两个查询的结果集的两个基本规则是：

所有查询中的列数和列的顺序必须相同。


数据类型必须兼容。

[duanduan1122]

2个条件必须都满足的时候,才可以.
看看你的环境满足吗?

[mschen]

你违反了Microsoft规定的创建视图的一个规定:

在用 UNION ALL 语句组合的表集中，同一个表不能出现两次。

很明显你的视图所引用的表viwPoint出现了两次

[长风大叔]

對於相同的表。請加別名來分開操作可以了。
SELECT DISTINCT [a.testLoa] AS mname, [a.tb1] AS nkey, ' ' AS nkey1,' ' AS ft FROM viwPoint a
union
SELECT DISTINCT [b.toor] AS mname, [b.wsk] AS nkey, b.testCity AS nkey1,' ' AS ft FROM viwPoint b
UNION
SELECT DISTINCT [c.fpID] AS mname, [c.www] AS nkey, c.testLoa AS nkey1,c.ft FROM viwPoint c