62,046
社区成员
发帖
与我相关
我的任务
分享
select a.PositionId,a.DegreeId,a.WorkYearId,,a.PositionId,b.DeptId,b.PositionId,b.DegreeId,b.WorkYearId,c.PersonName,c.DegreeId,c.WorkYearId
from RecruitReq as a
inner join RequestOrder as b
on a.ID=b.ReqId
left join HRResume as c
on c.Id=b.ResumeId
where a.DegreeId>=c.DegreeId and a.WorkYearId>=c.WorkYearId
select ro.*, rr.*, hr.*
from RequestOrder ro
join RecruitReq rr
on ro.ReqId = rr.ID
left join HRResume hr
on ro.ResumeId = hr.ID
where hr.DegreeId >= rr.DegreeId
and hr.WorkYearId >= rr.WorkYearId
select ro.*, rr.*, hr.*
from RequestOrder
join RecruitReq rr
on ro.ReqId = rr.ID
left join HRResume hr
on ro.ResumeId = hr.ID
where hr.DegreeId >= rr.DegreeId
and hr.WorkYearId >= rr.WorkYearId