mysql - How to check condition in a query. -

i have 2 tables fdone, incident_one.

fdone contains 4 coloums.

 inc_key,lat,long,fdid. 

incident_one contains five coloums.

inc_key,lat,long,state,fdid. 

i making fdone table lat long 2 4 query.

select s.`lat `,s.`long `,(s.`lat `+5)as x,(s.`long `-5)as y `fdheader` s 

and as

lat,long,x,y

and using join query.

i have check as,

incident_one lat , long inside lat,long,x,y.

i have check as..,

s.lat<lat ,s.long<long,x>long,y<long. 

i have check condition sql statement.

shall u me join query.

i need needful join query.

join  using fdid 

thanks in advances..,

may it's

select * fdone fd inner join incident_one io on fd.fdid=io.fdid io.late in (fd.late-5,fd.late)  , io.long in (fd.long-5,fd.long) ;