union的一个问题,50分求救
Select A.FirstName+' '+isNUll(A.MiddleName, ' ')+A.LastName As EmployeeName,'11' As ProjectName,getdate() as EndDate,1 as Status,A.EmployeeID as EmployeeID
From S_EMPLOYEE A
where A.employeeid not in (select distinct employeeid from s_emp_assignment)
and A.EmployeeID IN (Select EmployeeID From S_EMP_SKILLS Where (SkillID=1 and Proficiency>=0 and Months>=0) group by EmployeeID having count(EmployeeID)=1) order by EmployeeName
union
Select distinct A.FirstName+' '+isNUll(A.MiddleName, ' ')+A.LastName As EmployeeName,C.ProjectName as ProjectName,B.EndDate as EndDate,B.WorkStatus as Status,A.EmployeeID as EmployeeID From S_EMPLOYEE A,S_EMP_ASSIGNMENT B,S_PROJECTSET C
Where A.EmployeeID=B.EmployeeID AND B.ProjectID=C.ProjectID AND B.StartDate<getdate() AND B.EndDate>getdate()
and A.EmployeeID IN (Select EmployeeID From S_EMP_SKILLS Where (SkillID=1 and Proficiency>=0 and Months>=0) group by EmployeeID having count(EmployeeID)=1) order by EmployeeName
查询语句如上,问题很奇怪
目前是上面查询的结果为0,下面有结果,但是抱错,说union有错误
如果上面查询有结果,就可以运行.为什么会这样?