sql - My database is fetching duplicate records when i am working with server 2003 in mysql -

select empid,e.cur_vc_firstname_nn,d.deptname,ltid,fromleavedate,fromleavetype,toleavedate,toleavetype,num_lev_days  lmsdb.leaves l,lmsdb.department d,lmsdb.emp_pas_data e  l.empid=e.cur_c_empno_pk      , d.deptid=e.cur_c_dept_cd_cfk      , empid in (select cur_c_empno_pk                    lmsdb.emp_pas_data                    uni_vc_unit_desc_nn='hyderabad')      , lev_status='2'      , toleavedate>'2013-06-27'      , fromleavedate<'2013-07-28'  order d.deptname,empid asc; 

this query working server 2003. same query when work window xp mysql working properly.

select empid,e.cur_vc_firstname_nn,d.deptname,ltid,fromleavedate,fromleavetype,toleavedate,toleavetype,num_lev_days     lmsdb.leaves l,        lmsdb.department d,        lmsdb.emp_pas_data e    l.empid=e.cur_c_empno_pk            , d.deptid=e.cur_c_dept_cd_cfk            , e.uni_vc_unit_desc_nn='hyderabad')            , lev_status='2'            , toleavedate>'2013-06-27'            , fromleavedate<'2013-07-28'   order d.deptname,empid asc; 

your query looks correct. should check duplicate rows in either table lmsdb.leaves or in lmsdb.emp_pas_data