您所在位置：主题：关于SELECT UNION语句
allissa
[专家分：0] 发布于 2006-01-18 11:09:00
请问,各位这句SQL语句哪里有问题.
SELECT email, 'N' AS member FROM Order_Epose UNION (SELECT email, 'Y' AS member FROM Member_NET)
运行时,出现
"
服务器: 消息 446，级别 16，状态 9，行 1
Cannot resolve collation conflict for UNION operation.
"
错误信息.
SELECT email, 'N' AS member FROM Order_Epose UNION (SELECT email, 'Y' AS member FROM Member_NET)
运行时,出现
"
服务器: 消息 446，级别 16，状态 9，行 1
Cannot resolve collation conflict for UNION operation.
"
错误信息.