我在使用Sql Join时遇到问题 [英] I am having trouble with Sql Join

问题描述

  SELECT  Student.StudentID，（Student.FirstName + ' < span class =code-string>' + Student.LastName）
  AS  StudentName，Employee.EmployeeID，（Employee.FirstName + ' ' + Employee.LastName）
  FROM 学生 INNER   JOIN 员工 ON 学生.BranchID = Employee.BranchID 
  WHERE  Student.BranchID  OR  Employee.BranchID =   + ViewState [ BranchID  ] +; 

我在使用此Join时遇到问题。它显示以下内容错误..



表达式在预期条件的上下文中指定的非布尔类型，在'OR'附近。

解决方案

使用任何一个Student.BranchID / Employee.BranchID，但不是

在你没有指定valut的where条件下与Student.BranchID比较



WHERE Student.BranchID OR Employee.BranchID =+ ViewState [BranchID] +;



它应该像



WHERE Student.BranchID ='someValue' OR Employee.BranchID =+ ViewState [ BranchID] +;

这是一个愚蠢的错误。错误本身说的是：

Quote：

在预期条件的上下文中指定的非布尔类型的表达式，靠近OR。 / blockquote>

所以试试吧，

 SELECT Student.StudentID，（Student.FirstName +''+ Student.LastName）
 AS StudentName，Employee.EmployeeID，（Employee.FirstName +''+ Employee.LastName）
 FROM Student INNER JOIN Employee ON Student.BranchID = Employee.BranchID 
 WHERE Student.BranchID =+ ViewState [BranchID ]+ OR Employee.BranchID =+ ViewState [BranchID]; 

-KR

SELECT Student.StudentID,(Student.FirstName+' '+Student.LastName)
AS StudentName,Employee.EmployeeID,(Employee.FirstName+' '+Employee.LastName)
FROM Student INNER JOIN Employee ON Student.BranchID=Employee.BranchID
WHERE Student.BranchID OR Employee.BranchID="+ ViewState["BranchID"] + ";

I am having trouble with this Join .It is Showing the following error..

An expression of non-boolean type specified in a context where a condition is expected, near 'OR'.

解决方案

use any one either Student.BranchID/Employee.BranchID, but not both

in your where condition you have not specified valut to compare with Student.BranchID

WHERE Student.BranchID OR Employee.BranchID="+ ViewState["BranchID"] + ";

It should be like

WHERE Student.BranchID='someValue' OR Employee.BranchID="+ ViewState["BranchID"] + ";

It's a silly mistake. Error itself says something :

Quote:

An expression of non-boolean type specified in a context where a condition is expected, near 'OR'.

So try with this,

SELECT Student.StudentID,(Student.FirstName+' '+Student.LastName)
AS StudentName,Employee.EmployeeID,(Employee.FirstName+' '+Employee.LastName)
FROM Student INNER JOIN Employee ON Student.BranchID=Employee.BranchID
WHERE Student.BranchID="+ ViewState["BranchID"]"+ OR Employee.BranchID="+ ViewState["BranchID"]";

-KR

这篇关于我在使用Sql Join时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！