yes ar, Access sql .....
So i don't know how to post my sturture........
tablename: Candidate
----------------------------------
candidate_id char(key)
candidate_no char
tablename: Education
----------------------------------
education_id char(key)
candidate_no char
tablename: Working
----------------------------------
working_id char(key)
candidate_no char
w.from_year int
w.to_year int
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
having sum(datediff('yyyy','01/01/' & w.from_year ,'01/01/' & w.to_year )) >= 1
what is my wrong in this statement ?
Anyone know how can i do, please thx?