22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT Job.* FROM Job,
(SELECT ResumeExpect.* FROM ResumeExpect,Resume Where Resume.ResumeID=ResumeExpect.ResumeID AND Resume.AccountID=1) as Job2 ,
(SELECT Job.* FROM Job,ApplyJobRecord WHERE Job.JobID = ApplyJobRecord.JobID AND ApplyJobRecord.AccountID=1) as Job3
where
(
case when Job.CityID=Job2.ExpectWorkCityID then 1 else 0 end+
case when Job.FunctionID=Job2.ExpectFunctionID then 1 else 0 end+
case when Job.CityID=Job3.CityID then 1 else 0 end+
case when Job.FunctionID=Job3.FunctionID then 1 else 0 end
)=4
这是我现在只能查询符合条件的分数