how to inner join Query

SELECT country.country_name,state.statename,state.stid
FROM country
INNER JOIN state
ON country.id=state.coid
ORDER BY country.country_name;