我的查询不起作用.为什么 ? [英] my query doesn't work . Why ?

问题描述

你好
我在sql server 2008中有一个查询

Hello
I have a query in sql server 2008

SELECT  r.[Name] FROM [Center] c
INNER JOIN SwitchType s ON c.[ID] = s.[ID]
RIGHT JOIN [ReportType] r ON c.[ID]= r.[ID]

它的工作很好.但我在查询中添加条件不起作用.例如

its work good . but I add condition to my query its doesn''t work . for example

SELECT  r.[Name] FROM [Center] c
INNER JOIN SwitchType s ON c.[ID] = s.[ID]
RIGHT JOIN [ReportType] r ON c.[ID]= r.[ID]
where c.[Name] = 'a'

为什么 ?请帮我.

why ? pleas help me .

推荐答案

可能是找不到任何结果，而您的中心表名称列= a
我认为你需要使用像.

may be it doesnt find any result where your center table name column = a
i think you need to use like.

SELECT  r.[Name] FROM [Center] c
INNER JOIN SwitchType s ON c.[ID] = s.[ID]
RIGHT JOIN [ReportType] r ON c.[ID]= r.[ID]
where c.[Name] like 'a%'

查看更多 http://www.w3schools.com/sql/sql_like.asp [

see more http://www.w3schools.com/sql/sql_like.asp[^]

这篇关于我的查询不起作用.为什么 ?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！