mysql - How to inner join table? -

i have table

patient_detail has id , name , check_in_id , check_out_id .

check_out has check_out_id , illness_id , check_out_date.

check_in has check_in_id , illness_id , check_in_date .

illnesshas illness_id , illness_name .

problem don know how join illness_name check_out table.

use pantiendatabase  select name,check_in,illness_name,check_out_id check_in ci inner join patient_detail p  on ci.check_in_id = p.check_in_id  inner join illness  on i.illnessid  =ci.illness_id inner join  check_out co on co.check_out_id = p.check_out_id 

you can join same table twice , use aliases selected columns:

select name, check_in,        ii.illness_name illness_name_in,        io.illness_name illness_name_out,        check_out_id check_in ci inner join patient_detail p on ci.check_in_id = p.check_in_id  inner join illness ii on ii.illnessid = ci.illness_id inner join check_out co on co.check_out_id = p.check_out_id inner join illness io on io.illnessid = co.illness_id