Sql子查询错误问题 [英] Sql subquery error problem

问题描述

我在sql 2008中使用这个子查询

但是得到一个错误plz heml。

i am using this subquery in sql 2008
but getting an error plz heml.

SELECT  Name, UserName,Gender,Location,user_skill,intro  FROM wizom_User_Signup_Info
WHERE   UserName in(select UserName from Wiz_skill_details where Category_Name='IT' )

错误是

消息468，级别16，状态9，行1

无法解决Latin1_General_CI_AI和SQL_Latin1_General_CP1_CI_AS之间的排序规则冲突等于操作。

error is
Msg 468, Level 16, State 9, Line 1
Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

推荐答案

执行此查询它将查询。如果不让我知道..

Execute this Query""it will query.If not let me know..

SELECT  Name, UserName,Gender,Location,user_skill,intro  FROM wizom_User_Signup_Info
WHERE   UserName in(select UserName COLLATE Latin1_General_CI_AI from Wiz_skill_details where Category_Name='IT' )

检查有关Collat​​e的示例

Check example about Collate

DECLARE @A  VARCHAR(10)
SELECT @A = 'a'

IF (@A = 'A')
PRINT 'Match'
ELSE
PRINT 'No Match'
----------------------Execute seperately------------------------------
DECLARE @A  VARCHAR(10)
SELECT @A = 'a'

IF (@A = 'A' COLLATE SQL_Latin1_General_CP1_CS_AS)
PRINT 'Match'
ELSE
PRINT 'No Match'

选择J_id，电子邮件，fname，cl，mbn，性别，注册资格，其中J_id in（select从登录处整理Latin1_General_CI_AI J_id，其中active =''True''）

此查询显示错误关键字''collat​​e''附近的语法错误

select J_id,email,fname,cl,mbn,gender,qualification from registration where J_id in(select collate Latin1_General_CI_AI J_id from login where active=''True'' )
this query is showing error Incorrect syntax near the keyword ''collate''

这篇关于Sql子查询错误问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！