Hi query with more relation

--000e0cd32a60c8a57f046ed03022
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi all


*country*

ID
Name
Tel_Code
ActiveInd


103 India 91 1


104 Indonesia 62 1


105 Iran 98 1


106 Iraq 964 1
*city*

*ID
*

*Name
*

*ActiveInd
*

1

chennai

1

2

mumbai

1

3

pattaya

1


*country_city*

*ID
*

*City_ID
*

*Country_ID
*

*ActiveInd
*





1

1

103

1

2

2

103

1

3

3

216

1

Hi can i want the query which display the below output


*Cityname | countryname | cityid | countryid*

chennai | india | 1 | 103

mumbai | india | 2 | 103


Can u please the query ,

--000e0cd32a60c8a57f046ed03022--