List of records by joining three tables( Country , State, City )

CODECOUNTRYDelSTATE _IDSTATEDelCITY_IDCITYDel
AFGAFGHANISTAN12Qandahar 16Qandahar
AFGAFGHANISTAN13Herat 17Herat
AFGAFGHANISTAN14Balkh 18Mazar-e-Sharif
AUSAUSTRALIA46Victoria 127Melbourne
AUSAUSTRALIA48West Australia 130Perth
AUSAUSTRALIA49South Australia 131Adelaide
AUSAUSTRALIA50Capital Region 132Canberra
AUSAUSTRALIA51Queensland 133Brisbane
AUSAUSTRALIA51Queensland 134Gold Coast
CANCANADA25Québec 37Montréal
CANCANADA26Alberta 38Calgary
CANCANADA26Alberta 39Edmonton
CANCANADA27Ontario 40Toronto
CANCANADA27Ontario 41North York
CANCANADA27Ontario 42Mississauga
CANCANADA27Ontario 43Scarborough
CANCANADA27Ontario 44Etobicoke
CANCANADA29Manitoba 50Winnipeg
CANCANADA33British Columbia 63Vancouver
GBRGREAT BRITAIN35England 69London
GBRGREAT BRITAIN35England 70Birmingham
GBRGREAT BRITAIN35England 71Liverpool
GBRGREAT BRITAIN35England 72Sheffield
GBRGREAT BRITAIN35England 73Manchester
GBRGREAT BRITAIN35England 74Leeds
GBRGREAT BRITAIN35England 75Bristol
GBRGREAT BRITAIN37Scotland 83Glasgow
GBRGREAT BRITAIN37Scotland 84Edinburgh
GBRGREAT BRITAIN44Wales 122Cardiff
INDINDIA1Maharashtra 1Mumbai (Bombay)
INDINDIA1Maharashtra 2Nagpur
INDINDIA2Delhi 3Delhi
INDINDIA3West Bengali 4Calcutta [Kolkata]
INDINDIA4Tamil Nadu 5Chennai (Madras)
INDINDIA5Andhra Pradesh 6Hyderabad
INDINDIA6Gujarat 7Ahmedabad
INDINDIA7Karnataka 8Bangalore
INDINDIA8Uttar Pradesh 9Kanpur
INDINDIA8Uttar Pradesh 10Lucknow
INDINDIA9Maharashtra 11Mumbai (Bombay)
INDINDIA9Maharashtra 12Nagpur
USAUSA15New York 19New York
USAUSA16California 20Los Angeles
USAUSA16California 21San Diego
USAUSA17Illinois 22Chicago
USAUSA18Texas 23Houston
USAUSA18Texas 24Dallas
USAUSA18Texas 25San Antonio
USAUSA19Pennsylvania 26Philadelphia
USAUSA20Arizona 27Phoenix
USAUSA21California 28Los Angeles
USAUSA21California 29San Diego
USAUSA24Michigan 36Detroit