select distinct (c.candidate_no) FROM ((candidate as c left JOIN education as e ON c.candidate_no = e.candidate_no ) left Join working as w ON c.candidate_no = w.candidate_no )group by c.candidate_no,c.last_name ,c.nick_name, IIf( c.dob = ' / /',0,DATEDIFF('yyyy',c.dob,now) ) , c.mobile,c.expect_salary,c.available_option,e.level,e.institute,w.Industry,w.work_position,w.place,w.employer,w.duty,w.Achievement having 1 = 1 and sum(datediff('yyyy','01/01/' & w.from_year ,'01/01/' & w.to_year )) >= 1