select
r.IDNo,[r.Name],r.DepartmentCode,r.PositionCode,r.Governor,r.Inspector,r.WrittenExam,
r.Result,r.RecruiteTimes,r.RecruiteDate, d.DepartmentName,p.PositionName
from RecruiterMaster as r left join DepartmentMaster as d on r.departmentcode = d.departmentcode
left join positionmaster as p on r.positioncode = p.positioncode
r.IDNo,[r.Name],r.DepartmentCode,r.PositionCode,r.Governor,r.Inspector,r.WrittenExam,
r.Result,r.RecruiteTimes,r.RecruiteDate, d.DepartmentName,p.PositionName
from RecruiterMaster as r left join DepartmentMaster as d on r.departmentcode = d.departmentcode
left join positionmaster as p on r.positioncode = p.positioncode
r.IDNo,[r.Name],r.DepartmentCode,r.PositionCode,r.Governor,r.Inspector,r.WrittenExam,
r.Result,r.RecruiteTimes,r.RecruiteDate, d.DepartmentName,p.PositionName
from RecruiterMaster as r left join DepartmentMaster as d on r.departmentcode = d.departmentcode
left join positionmaster as p on r.positioncode = p.positioncode
select
r.IDNo,r.[Name],r.DepartmentCode,r.PositionCode,r.Governor,r.Inspector,r.WrittenExam,
r.Result,r.RecruiteTimes,r.RecruiteDate, d.DepartmentName,p.PositionName
from RecruiterMaster as r
left join DepartmentMaster as d on r.departmentcode collate Chinese_PRC_CI_AS = d.departmentcode collate Chinese_PRC_CI_AS
left join positionmaster as p on r.positioncode collate Chinese_PRC_CI_AS= p.positioncode collate Chinese_PRC_CI_AS
select
r.IDNo,r.DepartmentCode,r.PositionCode,
d.DepartmentName,p.PositionName
from RecruiterMaster as r left join DepartmentMaster as d
on r.departmentcode = d.departmentcode
left join positionmaster as p
on r.positioncode = p.positioncode也有相同的问题,查了一下,好像是排序规则的问题,没查太明白,高手帮帮忙!