select *
from Achievement
where Achievement.EmpID = Employees.EmpID
这个语句分析没错误,执行确提示错误信息:
消息 4104,级别 16,状态 1,第 1 行
无法绑定由多个部分组成的标识符 "Employees.EmpID"。
from Achievement
where Achievement.EmpID = Employees.EmpID
这个语句分析没错误,执行确提示错误信息:
消息 4104,级别 16,状态 1,第 1 行
无法绑定由多个部分组成的标识符 "Employees.EmpID"。
from Achievement, Employees
where Achievement.EmpID = Employees.EmpID
from Achievement,Employees
where Achievement.EmpID = Employees.EmpID
select * from Achievement,Employees
where Achievement.EmpID = Employees.EmpID
select a.* from Achievement a,Employees b
where a.EmpID = b.EmpID
(select EmpName from Employees where Employees.EmpID=Achievement.EmpID)as 'EmpName',
(select EmpSex from Employees where Employees.EmpID=Achievement.EmpID )as 'EmpSex'
from Achievement,Employees
where Achievement.signal=1 and Achievement.EmpID = Employees.EmpID
由于我在Employees表中将EmpSex设成bit型,这样显示是0或1,怎么才能显示‘男’‘女’
select *
from Achievement,Employees
where Achievement.EmpID = Employees.EmpID
(select EmpName from Employees where Employees.EmpID=Achievement.EmpID)as 'EmpName',
(select case when EmpSex=1 then '男' else '女' end from Employees where Employees.EmpID=Achievement.EmpID )as 'EmpSex'
from Achievement,Employees
where Achievement.signal=1 and Achievement.EmpID = Employees.EmpID
select sex =case sex
when '1 ' then '男 '
else '女 '
end
from TB