Inner Join
The table below shows City ID, City from City table and Country from Country table share the same Country ID
City_ID |
City |
Country |
251 | Kabul | Afghanistan |
59 | Batna | Algeria |
63 | Bchar | Algeria |
482 | Skikda | Algeria |
515 | Tafuna | American Samoa |
67 | Benguela | Angola |
359 | Namibe | Angola |
492 | South Hill | Anguilla |
20 | Almirante Brown | Argentina |
43 | Avellaneda | Argentina |
45 | Baha Blanca | Argentina |
128 | Crdoba | Argentina |
161 | Escobar | Argentina |
165 | Ezeiza | Argentina |
289 | La Plata | Argentina |
333 | Merlo | Argentina |
423 | Quilmes | Argentina |
453 | San Miguel de Tucumn | Argentina |
456 | Santa F | Argentina |
523 | Tandil | Argentina |
566 | Vicente Lpez | Argentina |
585 | Yerevan | Armenia |
575 | Woodridge | Australia |
186 | Graz | Austria |
307 | Linz | Austria |
446 | Salzburg | Austria |
48 | Baku | Azerbaijan |
504 | Sumqayit | Azerbaijan |
14 | al-Manama | Bahrain |
143 | Dhaka | Bangladesh |
234 | Jamalpur | Bangladesh |
524 | Tangail | Bangladesh |
338 | Mogiljov | Belarus |
339 | Molodetno | Belarus |
153 | El Alto | Bolivia |
500 | Sucre | Bolivia |
21 | Alvorada | Brazil |
25 | Angra dos Reis | Brazil |
26 | Anpolis | Brazil |
28 | Aparecida de Goinia | Brazil |
30 | Araatuba | Brazil |
44 | Bag | Brazil |
66 | Belm | Brazil |
83 | Blumenau | Brazil |
84 | Boa Vista | Brazil |
89 | Braslia | Brazil |
183 | Goinia | Brazil |
189 | Guaruj | Brazil |
190 | guas Lindas de Gois | Brazil |
215 | Ibirit | Brazil |
247 | Juazeiro do Norte | Brazil |
248 | Juiz de Fora | Brazil |
316 | Luzinia | Brazil |
327 | Maring | Brazil |
409 | Po | Brazil |
412 | Poos de Caldas | Brazil |
430 | Rio Claro | Brazil |
455 | Santa Brbara dOeste | Brazil |
460 | Santo Andr | Brazil |
484 | So Bernardo do Campo | Brazil |
485 | So Leopoldo | Brazil |
489 | Sorocaba | Brazil |
568 | Vila Velha | Brazil |
571 | Vitria de Santo Anto | Brazil |
53 | Bandar Seri Begawan | Brunei |
435 | Ruse | Bulgaria |
497 | Stara Zagora | Bulgaria |
60 | Battambang | Cambodia |
405 | Phnom Penh | Cambodia |
52 | Bamenda | Cameroon |
584 | Yaound | Cameroon |
179 | Gatineau | Canada |
196 | Halifax | Canada |
300 | Lethbridge | Canada |
382 | Oshawa | Canada |
429 | Richmond Hill | Canada |
564 | Vancouver | Canada |
362 | NDjamna | Chad |
27 | Antofagasta | Chile |
127 | Coquimbo | Chile |
427 | Rancagua | Chile |
46 | Baicheng | China |
47 | Baiyin | China |
80 | Binzhou | China |
109 | Changzhou | China |
136 | Datong | China |
139 | Daxian | China |
145 | Dongying | China |
157 | Emeishan | China |
159 | Enshi | China |
166 | Ezhou | China |
174 | Fuyu | China |
175 | Fuzhou | China |
193 | Haining | China |
199 | Hami | China |
207 | Hohhot | China |
210 | Huaian | China |
240 | Jinchang | China |
241 | Jining | China |
242 | Jinzhou | China |
249 | Junan | China |
277 | Korla | China |
291 | Laiwu | China |
293 | Laohekou | China |
298 | Lengshuijiang | China |
299 | Leshan | China |
302 | Liaocheng | China |
331 | Meixian | China |
361 | Nanyang | China |
406 | Pingxiang | China |
421 | Qinhuangdao | China |
431 | Rizhao | China |
461 | Sanya | China |
467 | Shanwei | China |
468 | Shaoguan | China |
470 | Shenzhen | China |
501 | Suihua | China |
534 | Tianjin | China |
535 | Tiefa | China |
536 | Tieli | China |
539 | Tongliao | China |
573 | Weifang | China |
577 | Xiangfan | China |
578 | Xiangtan | China |
579 | Xintai | China |
580 | Xinxiang | China |
583 | Yantai | China |
586 | Yinchuan | China |
587 | Yingkou | China |
589 | Yuncheng | China |
590 | Yuzhou | China |
591 | Zalantun | China |
593 | Zaoyang | China |
598 | Zhoushan | China |
96 | Buenaventura | Colombia |
147 | Dos Quebradas | Colombia |
170 | Florencia | Colombia |
404 | Pereira | Colombia |
479 | Sincelejo | Colombia |
486 | Sogamoso | Colombia |
314 | Lubumbashi | Congo The Democratic Republic of the |
347 | Mwene-Ditu | Congo The Democratic Republic of the |
377 | Olomouc | Czech Republic |
290 | La Romana | Dominican Republic |
449 | San Felipe de Puerto Plata | Dominican Republic |
459 | Santiago de los Caballeros | Dominican Republic |
311 | Loja | Ecuador |
413 | Portoviejo | Ecuador |
433 | Robamba | Ecuador |
79 | Bilbays | Egypt |
216 | Idfu | Egypt |
336 | Mit Ghamr | Egypt |
420 | Qalyub | Egypt |
464 | Sawhaj | Egypt |
475 | Shubra al-Khayma | Egypt |
529 | Tartu | Estonia |
6 | Addis Abeba | Ethiopia |
544 | Trshavn | Faroe Islands |
386 | Oulu | Finland |
92 | Brest | France |
297 | Le Mans | France |
542 | Toulon | France |
543 | Toulouse | France |
105 | Cayenne | French Guiana |
167 | Faaa | French Polynesia |
396 | Papeete | French Polynesia |
54 | Banjul | Gambia |
148 | Duisburg | Germany |
160 | Erlangen | Germany |
198 | Halle/Saale | Germany |
324 | Mannheim | Germany |
438 | Saarbrcken | Germany |
476 | Siegen | Germany |
574 | Witten | Germany |
38 | Athenai | Greece |
400 | Patras | Greece |
370 | Nuuk | Greenland |
121 | Citt del Vaticano | Holy See (Vatican City State) |
279 | Kowloon and New Kowloon | Hong Kong |
511 | Szkesfehrvr | Hungary |
8 | Adoni | India |
9 | Ahmadnagar | India |
18 | Allappuzha (Alleppey) | India |
22 | Ambattur | India |
24 | Amroha | India |
51 | Balurghat | India |
71 | Berhampore (Baharampur) | India |
73 | Bhavnagar | India |
74 | Bhilwara | India |
75 | Bhimavaram | India |
76 | Bhopal | India |
77 | Bhusawal | India |
78 | Bijapur | India |
107 | Chandrapur | India |
110 | Chapra | India |
144 | Dhule (Dhulia) | India |
164 | Etawah | India |
169 | Firozabad | India |
176 | Gandhinagar | India |
191 | Gulbarga | India |
195 | Haldia | India |
197 | Halisahar | India |
208 | Hoshiarpur | India |
211 | Hubli-Dharwad | India |
231 | Jaipur | India |
239 | Jhansi | India |
243 | Jodhpur | India |
257 | Kamarhati | India |
261 | Kanchrapara | India |
263 | Karnal | India |
264 | Katihar | India |
283 | Kumbakonam | India |
335 | Miraj | India |
345 | Munger (Monghyr) | India |
349 | Mysore | India |
353 | Nagaon | India |
394 | Palghat (Palakkad) | India |
397 | Parbhani | India |
398 | Pathankot | India |
399 | Patiala | India |
415 | Pudukkottai | India |
416 | Pune | India |
417 | Purnea (Purnia) | India |
424 | Rae Bareli | India |
425 | Rajkot | India |
426 | Rampur | India |
428 | Ranchi | India |
447 | Sambhal | India |
463 | Satna | India |
472 | Shimoga | India |
474 | Shivapuri | India |
477 | Siliguri (Shiliguri) | India |
521 | Tambaram | India |
549 | Udaipur | India |
553 | Uluberia | India |
558 | Uttarpara-Kotrung | India |
563 | Valparai | India |
565 | Varanasi (Benares) | India |
567 | Vijayawada | India |
581 | Yamuna Nagar | India |
117 | Cianjur | Indonesia |
118 | Ciomas | Indonesia |
119 | Ciparay | Indonesia |
184 | Gorontalo | Indonesia |
232 | Jakarta | Indonesia |
301 | Lhokseumawe | Indonesia |
317 | Madiun | Indonesia |
395 | Pangkal Pinang | Indonesia |
402 | Pemalang | Indonesia |
411 | Pontianak | Indonesia |
414 | Probolinggo | Indonesia |
418 | Purwakarta | Indonesia |
508 | Surakarta | Indonesia |
531 | Tegal | Indonesia |
31 | Arak | Iran |
162 | Esfahan | Iran |
265 | Kermanshah | Iran |
355 | Najafabad | Iran |
422 | Qomsheh | Iran |
466 | Shahr-e Kord | Iran |
480 | Sirjan | Iran |
513 | Tabriz | Iran |
343 | Mosul | Iraq |
34 | Ashdod | Israel |
36 | Ashqelon | Israel |
57 | Bat Yam | Israel |
532 | Tel Aviv-Jaffa | Israel |
17 | Alessandria | Italy |
70 | Bergamo | Italy |
91 | Brescia | Italy |
93 | Brindisi | Italy |
309 | Livorno | Italy |
510 | Syrakusa | Italy |
550 | Udine | Italy |
10 | Akishima | Japan |
172 | Fukuyama | Japan |
203 | Higashiosaka | Japan |
204 | Hino | Japan |
205 | Hiroshima | Japan |
224 | Isesaki | Japan |
226 | Iwaki | Japan |
227 | Iwakuni | Japan |
228 | Iwatsuki | Japan |
229 | Izumisano | Japan |
253 | Kakamigahara | Japan |
256 | Kamakura | Japan |
260 | Kanazawa | Japan |
276 | Koriyama | Japan |
284 | Kurashiki | Japan |
287 | Kuwana | Japan |
330 | Matsue | Japan |
337 | Miyakonojo | Japan |
354 | Nagareyama | Japan |
375 | Okayama | Japan |
376 | Okinawa | Japan |
379 | Omiya | Japan |
381 | Onomichi | Japan |
385 | Otsu | Japan |
439 | Sagamihara | Japan |
462 | Sasebo | Japan |
473 | Shimonoseki | Japan |
520 | Tama | Japan |
546 | Tsuyama | Japan |
551 | Ueda | Japan |
554 | Urawa | Japan |
401 | Pavlodar | Kazakstan |
597 | Zhezqazghan | Kazakstan |
271 | Kisumu | Kenya |
371 | Nyeri | Kenya |
233 | Jalib al-Shuyukh | Kuwait |
137 | Daugavpils | Latvia |
303 | Liepaja | Latvia |
559 | Vaduz | Liechtenstein |
569 | Vilnius | Lithuania |
318 | Mahajanga | Madagascar |
304 | Lilongwe | Malawi |
223 | Ipoh | Malaysia |
282 | Kuching | Malaysia |
506 | Sungai Petani | Malaysia |
4 | Acua | Mexico |
19 | Allende | Mexico |
40 | Atlixco | Mexico |
103 | Carmen | Mexico |
106 | Celaya | Mexico |
124 | Coacalco de Berriozbal | Mexico |
125 | Coatzacoalcos | Mexico |
129 | Cuauhtmoc | Mexico |
130 | Cuautla | Mexico |
131 | Cuernavaca | Mexico |
154 | El Fuerte | Mexico |
188 | Guadalajara | Mexico |
202 | Hidalgo | Mexico |
212 | Huejutla de Reyes | Mexico |
213 | Huixquilucan | Mexico |
246 | Jos Azueta | Mexico |
250 | Jurez | Mexico |
288 | La Paz | Mexico |
329 | Matamoros | Mexico |
334 | Mexicali | Mexico |
340 | Monclova | Mexico |
364 | Nezahualcyotl | Mexico |
392 | Pachuca de Soto | Mexico |
444 | Salamanca | Mexico |
450 | San Felipe del Progreso | Mexico |
451 | San Juan Bautista Tuxtepec | Mexico |
540 | Torren | Mexico |
555 | Uruapan | Mexico |
562 | Valle de Santiago | Mexico |
594 | Zapopan | Mexico |
115 | Chisinau | Moldova |
68 | Beni-Mellal | Morocco |
352 | Nador | Morocco |
442 | Sal | Morocco |
64 | Beira | Mozambique |
350 | Naala-Porto | Mozambique |
533 | Tete | Mozambique |
341 | Monywa | Myanmar |
348 | Myingyan | Myanmar |
582 | Yangor | Nauru |
81 | Birgunj | Nepal |
23 | Amersfoort | Netherlands |
29 | Apeldoorn | Netherlands |
151 | Ede | Netherlands |
158 | Emmen | Netherlands |
437 | s-Hertogenbosch | Netherlands |
200 | Hamilton | New Zealand |
69 | Benin City | Nigeria |
141 | Deba Habe | Nigeria |
152 | Effon-Alaiye | Nigeria |
217 | Ife | Nigeria |
218 | Ikerre | Nigeria |
220 | Ilorin | Nigeria |
252 | Kaduna | Nigeria |
373 | Ogbomosho | Nigeria |
380 | Ondo | Nigeria |
388 | Owo | Nigeria |
389 | Oyo | Nigeria |
487 | Sokoto | Nigeria |
595 | Zaria | Nigeria |
419 | Pyongyang | North Korea |
328 | Masqat | Oman |
443 | Salala | Oman |
134 | Dadu | Pakistan |
323 | Mandi Bahauddin | Pakistan |
326 | Mardan | Pakistan |
374 | Okara | Pakistan |
471 | Shikarpur | Pakistan |
37 | Asuncin | Paraguay |
122 | Ciudad del Este | Paraguay |
452 | San Lorenzo | Paraguay |
99 | Callao | Peru |
214 | Hunuco | Peru |
305 | Lima | Peru |
502 | Sullana | Peru |
61 | Baybay | Philippines |
62 | Bayugan | Philippines |
82 | Bislig | Philippines |
98 | Cabuyao | Philippines |
104 | Cavite | Philippines |
138 | Davao | Philippines |
182 | Gingoog | Philippines |
192 | Hagonoy | Philippines |
219 | Iligan | Philippines |
221 | Imus | Philippines |
294 | Lapu-Lapu | Philippines |
322 | Mandaluyong | Philippines |
390 | Ozamis | Philippines |
457 | Santa Rosa | Philippines |
516 | Taguig | Philippines |
518 | Talavera | Philippines |
522 | Tanauan | Philippines |
526 | Tanza | Philippines |
527 | Tarlac | Philippines |
547 | Tuguegarao | Philippines |
97 | Bydgoszcz | Poland |
133 | Czestochowa | Poland |
236 | Jastrzebie-Zdrj | Poland |
255 | Kalisz | Poland |
313 | Lublin | Poland |
408 | Plock | Poland |
548 | Tychy | Poland |
576 | Wroclaw | Poland |
32 | Arecibo | Puerto Rico |
410 | Ponce | Puerto Rico |
86 | Botosani | Romania |
95 | Bucuresti | Romania |
441 | Saint-Denis | Runion |
39 | Atinsk | Russian Federation |
49 | Balaiha | Russian Federation |
150 | Dzerzinsk | Russian Federation |
156 | Elista | Russian Federation |
225 | Ivanovo | Russian Federation |
235 | Jaroslavl | Russian Federation |
238 | Jelets | Russian Federation |
254 | Kaliningrad | Russian Federation |
259 | Kamyin | Russian Federation |
270 | Kirovo-Tepetsk | Russian Federation |
274 | Kolpino | Russian Federation |
278 | Korolev | Russian Federation |
285 | Kurgan | Russian Federation |
286 | Kursk | Russian Federation |
308 | Lipetsk | Russian Federation |
310 | Ljubertsy | Russian Federation |
319 | Maikop | Russian Federation |
342 | Moscow | Russian Federation |
351 | Nabereznyje Telny | Russian Federation |
366 | Niznekamsk | Russian Federation |
368 | Novoterkassk | Russian Federation |
407 | Pjatigorsk | Russian Federation |
465 | Serpuhov | Russian Federation |
483 | Smolensk | Russian Federation |
509 | Syktyvkar | Russian Federation |
530 | Teboksary | Russian Federation |
557 | Usolje-Sibirskoje | Russian Federation |
596 | Zeleznogorsk | Russian Federation |
269 | Kingstown | Saint Vincent and the Grenadines |
2 | Abha | Saudi Arabia |
13 | al-Hawiya | Saudi Arabia |
16 | al-Qatif | Saudi Arabia |
237 | Jedda | Saudi Arabia |
514 | Tabuk | Saudi Arabia |
599 | Ziguinchor | Senegal |
90 | Bratislava | Slovakia |
85 | Boksburg | South Africa |
87 | Botshabelo | South Africa |
112 | Chatsworth | South Africa |
244 | Johannesburg | South Africa |
267 | Kimberley | South Africa |
273 | Klerksdorp | South Africa |
363 | Newcastle | South Africa |
391 | Paarl | South Africa |
436 | Rustenburg | South Africa |
490 | Soshanguve | South Africa |
496 | Springs | South Africa |
113 | Cheju | South Korea |
268 | Kimchon | South Korea |
356 | Naju | South Korea |
538 | Tonghae | South Korea |
552 | Uijongbu | South Korea |
1 | A Corua (La Corua) | Spain |
146 | Donostia-San Sebastin | Spain |
181 | Gijn | Spain |
387 | Ourense (Orense) | Spain |
458 | Santiago de Compostela | Spain |
230 | Jaffna | Sri Lanka |
15 | al-Qadarif | Sudan |
378 | Omdurman | Sudan |
320 | Malm | Sweden |
56 | Basel | Switzerland |
72 | Bern | Switzerland |
296 | Lausanne | Switzerland |
108 | Changhwa | Taiwan |
114 | Chiayi | Taiwan |
116 | Chungho | Taiwan |
168 | Fengshan | Taiwan |
209 | Hsichuh | Taiwan |
315 | Lungtan | Taiwan |
360 | Nantou | Taiwan |
525 | Tanshui | Taiwan |
541 | Touliu | Taiwan |
545 | Tsaotun | Taiwan |
346 | Mwanza | Tanzania |
512 | Tabora | Tanzania |
592 | Zanzibar | Tanzania |
357 | Nakhon Sawan | Thailand |
393 | Pak Kret | Thailand |
488 | Songkhla | Thailand |
369 | Nukualofa | Tonga |
491 | Sousse | Tunisia |
5 | Adana | Turkey |
50 | Balikesir | Turkey |
58 | Batman | Turkey |
142 | Denizli | Turkey |
163 | Eskisehir | Turkey |
180 | Gaziantep | Turkey |
222 | Inegl | Turkey |
266 | Kilis | Turkey |
281 | Ktahya | Turkey |
383 | Osmaniye | Turkey |
481 | Sivas | Turkey |
503 | Sultanbeyli | Turkey |
528 | Tarsus | Turkey |
537 | Tokat | Turkey |
556 | Usak | Turkey |
35 | Ashgabat | Turkmenistan |
173 | Funafuti | Tuvalu |
258 | Kamjanets-Podilskyi | Ukraine |
275 | Konotop | Ukraine |
344 | Mukateve | Ukraine |
384 | ostka | Ukraine |
478 | Simferopol | Ukraine |
505 | Sumy | Ukraine |
3 | Abu Dhabi | United Arab Emirates |
12 | al-Ayn | United Arab Emirates |
469 | Sharja | United Arab Emirates |
88 | Bradford | United Kingdom |
149 | Dundee | United Kingdom |
312 | London | United Kingdom |
493 | Southampton | United Kingdom |
494 | Southend-on-Sea | United Kingdom |
495 | Southport | United Kingdom |
499 | Stockport | United Kingdom |
588 | York | United Kingdom |
11 | Akron | United States |
33 | Arlington | United States |
41 | Augusta-Richmond County | United States |
42 | Aurora | United States |
65 | Bellevue | United States |
94 | Brockton | United States |
101 | Cape Coral | United States |
120 | Citrus Heights | United States |
123 | Clarksville | United States |
126 | Compton | United States |
135 | Dallas | United States |
140 | Dayton | United States |
155 | El Monte | United States |
171 | Fontana | United States |
177 | Garden Grove | United States |
178 | Garland | United States |
185 | Grand Prairie | United States |
187 | Greensboro | United States |
245 | Joliet | United States |
262 | Kansas City | United States |
292 | Lancaster | United States |
295 | Laredo | United States |
306 | Lincoln | United States |
321 | Manchester | United States |
332 | Memphis | United States |
403 | Peoria | United States |
432 | Roanoke | United States |
434 | Rockford | United States |
440 | Saint Louis | United States |
445 | Salinas | United States |
448 | San Bernardino | United States |
498 | Sterling Heights | United States |
507 | Sunnyvale | United States |
519 | Tallahassee | United States |
572 | Warren | United States |
600 | Texas | United States |
55 | Barcelona | Venezuela |
102 | Caracas | Venezuela |
132 | Cuman | Venezuela |
325 | Maracabo | Venezuela |
372 | Ocumare del Tuy | Venezuela |
560 | Valencia | Venezuela |
561 | Valle de la Pascua | Venezuela |
100 | Cam Ranh | Vietnam |
194 | Haiphong | Vietnam |
201 | Hanoi | Vietnam |
358 | Nam Dinh | Vietnam |
365 | Nha Trang | Vietnam |
570 | Vinh | Vietnam |
111 | Charlotte Amalie | Virgin Islands U.S. |
7 | Aden | Yemen |
206 | Hodeida | Yemen |
454 | Sanaa | Yemen |
517 | Taizz | Yemen |
280 | Kragujevac | Yugoslavia |
367 | Novi Sad | Yugoslavia |
272 | Kitwe | Zambia |