消息 102，级别 15，状态 1，第 8 行' ' 附近有语法错误。

[lude8880]

select a.Name
FROM Contacts a inner join
BuildFinishedEventSubscribers b on
a.id=b.contactId inner join BuildDefinition c
on b.DefinitionId=c.id inner join Projects d on
d.id=c.ProjectId WHERE c.DefinitionName='ALLBUILDDEFINITION'
AND d.name='OpenTest'
AND　b.statusId='2'
AND
b.isEnabled='True'

[水族杰纶]

select a.Name FROM Contacts a inner join BuildFinishedEventSubscribers b on a.id=b.contactId  inner join BuildDefinition c 
on b.DefinitionId=c.id inner join Projects d on d.id=c.ProjectId WHERE  c.DefinitionName='ALLBUILDDEFINITION' 
AND d.name='OpenTest' AND b.statusId='2' AND b.isEnabled='True'

[lude8880]

AND　b.statusId='2'
这行有错误

[lude8880]

你的可以用，到底是哪错了？

[dj3688]

select a.Name 
FROM Contacts a inner join 
BuildFinishedEventSubscribers b on 
a.id=b.contactId  inner join BuildDefinition c 
on b.DefinitionId=c.id inner join Projects d on 
d.id=c.ProjectId WHERE  c.DefinitionName='ALLBUILDDEFINITION' 
AND d.name='OpenTest' 
AND b.statusId=2          
AND b.isEnabled='True'

try..

[lude8880]

搞定了，中文空格格

[ks_reny]

select a.Name 
FROM Contacts a 
inner join BuildFinishedEventSubscribers b on a.id=b.contactId  
inner join BuildDefinition c on b.DefinitionId=c.id 
inner join Projects d on d.id=c.ProjectId 
WHERE  c.DefinitionName='ALLBUILDDEFINITION' 
AND  d.name='OpenTest' 
AND　b.statusId=2 
AND  b.isEnabled='True'

[pop_kiner]

AND　b.statusId='2' 

这里可能输入法原因造成的
AND b.statusId='2'

[lude8880]

是中文空格的原因，多谢了