how to multiple table join for example LEFT Join

select c.country_name,s.statename,ct.cityname from country as c
left join state as s on (s.coid = c.id)
left join city as ct on (ct.stid = s.stid);