Menu

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
251KabulAfghanistan
59BatnaAlgeria
63BcharAlgeria
482SkikdaAlgeria
515TafunaAmerican Samoa
67BenguelaAngola
359NamibeAngola
492South HillAnguilla
20Almirante BrownArgentina
43AvellanedaArgentina
45Baha BlancaArgentina
128CrdobaArgentina
161EscobarArgentina
165EzeizaArgentina
289La PlataArgentina
333MerloArgentina
423QuilmesArgentina
453San Miguel de TucumnArgentina
456Santa FArgentina
523TandilArgentina
566Vicente LpezArgentina
585YerevanArmenia
575WoodridgeAustralia
186GrazAustria
307LinzAustria
446SalzburgAustria
48BakuAzerbaijan
504SumqayitAzerbaijan
14al-ManamaBahrain
143DhakaBangladesh
234JamalpurBangladesh
524TangailBangladesh
338MogiljovBelarus
339MolodetnoBelarus
153El AltoBolivia
500SucreBolivia
21AlvoradaBrazil
25Angra dos ReisBrazil
26AnpolisBrazil
28Aparecida de GoiniaBrazil
30AraatubaBrazil
44BagBrazil
66BelmBrazil
83BlumenauBrazil
84Boa VistaBrazil
89BrasliaBrazil
183GoiniaBrazil
189GuarujBrazil
190guas Lindas de GoisBrazil
215IbiritBrazil
247Juazeiro do NorteBrazil
248Juiz de ForaBrazil
316LuziniaBrazil
327MaringBrazil
409PoBrazil
412Poos de CaldasBrazil
430Rio ClaroBrazil
455Santa Brbara dOesteBrazil
460Santo AndrBrazil
484So Bernardo do CampoBrazil
485So LeopoldoBrazil
489SorocabaBrazil
568Vila VelhaBrazil
571Vitria de Santo AntoBrazil
53Bandar Seri BegawanBrunei
435RuseBulgaria
497Stara ZagoraBulgaria
60BattambangCambodia
405Phnom PenhCambodia
52BamendaCameroon
584YaoundCameroon
179GatineauCanada
196HalifaxCanada
300LethbridgeCanada
382OshawaCanada
429Richmond HillCanada
564VancouverCanada
362NDjamnaChad
27AntofagastaChile
127CoquimboChile
427RancaguaChile
46BaichengChina
47BaiyinChina
80BinzhouChina
109ChangzhouChina
136DatongChina
139DaxianChina
145DongyingChina
157EmeishanChina
159EnshiChina
166EzhouChina
174FuyuChina
175FuzhouChina
193HainingChina
199HamiChina
207HohhotChina
210HuaianChina
240JinchangChina
241JiningChina
242JinzhouChina
249JunanChina
277KorlaChina
291LaiwuChina
293LaohekouChina
298LengshuijiangChina
299LeshanChina
302LiaochengChina
331MeixianChina
361NanyangChina
406PingxiangChina
421QinhuangdaoChina
431RizhaoChina
461SanyaChina
467ShanweiChina
468ShaoguanChina
470ShenzhenChina
501SuihuaChina
534TianjinChina
535TiefaChina
536TieliChina
539TongliaoChina
573WeifangChina
577XiangfanChina
578XiangtanChina
579XintaiChina
580XinxiangChina
583YantaiChina
586YinchuanChina
587YingkouChina
589YunchengChina
590YuzhouChina
591ZalantunChina
593ZaoyangChina
598ZhoushanChina
96BuenaventuraColombia
147Dos QuebradasColombia
170FlorenciaColombia
404PereiraColombia
479SincelejoColombia
486SogamosoColombia
314LubumbashiCongo The Democratic Republic of the
347Mwene-DituCongo The Democratic Republic of the
377OlomoucCzech Republic
290La RomanaDominican Republic
449San Felipe de Puerto PlataDominican Republic
459Santiago de los CaballerosDominican Republic
311LojaEcuador
413PortoviejoEcuador
433RobambaEcuador
79BilbaysEgypt
216IdfuEgypt
336Mit GhamrEgypt
420QalyubEgypt
464SawhajEgypt
475Shubra al-KhaymaEgypt
529TartuEstonia
6Addis AbebaEthiopia
544TrshavnFaroe Islands
386OuluFinland
92BrestFrance
297Le MansFrance
542ToulonFrance
543ToulouseFrance
105CayenneFrench Guiana
167FaaaFrench Polynesia
396PapeeteFrench Polynesia
54BanjulGambia
148DuisburgGermany
160ErlangenGermany
198Halle/SaaleGermany
324MannheimGermany
438SaarbrckenGermany
476SiegenGermany
574WittenGermany
38AthenaiGreece
400PatrasGreece
370NuukGreenland
121Citt del VaticanoHoly See (Vatican City State)
279Kowloon and New KowloonHong Kong
511SzkesfehrvrHungary
8AdoniIndia
9AhmadnagarIndia
18Allappuzha (Alleppey)India
22AmbatturIndia
24AmrohaIndia
51BalurghatIndia
71Berhampore (Baharampur)India
73BhavnagarIndia
74BhilwaraIndia
75BhimavaramIndia
76BhopalIndia
77BhusawalIndia
78BijapurIndia
107ChandrapurIndia
110ChapraIndia
144Dhule (Dhulia)India
164EtawahIndia
169FirozabadIndia
176GandhinagarIndia
191GulbargaIndia
195HaldiaIndia
197HalisaharIndia
208HoshiarpurIndia
211Hubli-DharwadIndia
231JaipurIndia
239JhansiIndia
243JodhpurIndia
257KamarhatiIndia
261KanchraparaIndia
263KarnalIndia
264KatiharIndia
283KumbakonamIndia
335MirajIndia
345Munger (Monghyr)India
349MysoreIndia
353NagaonIndia
394Palghat (Palakkad)India
397ParbhaniIndia
398PathankotIndia
399PatialaIndia
415PudukkottaiIndia
416PuneIndia
417Purnea (Purnia)India
424Rae BareliIndia
425RajkotIndia
426RampurIndia
428RanchiIndia
447SambhalIndia
463SatnaIndia
472ShimogaIndia
474ShivapuriIndia
477Siliguri (Shiliguri)India
521TambaramIndia
549UdaipurIndia
553UluberiaIndia
558Uttarpara-KotrungIndia
563ValparaiIndia
565Varanasi (Benares)India
567VijayawadaIndia
581Yamuna NagarIndia
117CianjurIndonesia
118CiomasIndonesia
119CiparayIndonesia
184GorontaloIndonesia
232JakartaIndonesia
301LhokseumaweIndonesia
317MadiunIndonesia
395Pangkal PinangIndonesia
402PemalangIndonesia
411PontianakIndonesia
414ProbolinggoIndonesia
418PurwakartaIndonesia
508SurakartaIndonesia
531TegalIndonesia
31ArakIran
162EsfahanIran
265KermanshahIran
355NajafabadIran
422QomshehIran
466Shahr-e KordIran
480SirjanIran
513TabrizIran
343MosulIraq
34AshdodIsrael
36AshqelonIsrael
57Bat YamIsrael
532Tel Aviv-JaffaIsrael
17AlessandriaItaly
70BergamoItaly
91BresciaItaly
93BrindisiItaly
309LivornoItaly
510SyrakusaItaly
550UdineItaly
10AkishimaJapan
172FukuyamaJapan
203HigashiosakaJapan
204HinoJapan
205HiroshimaJapan
224IsesakiJapan
226IwakiJapan
227IwakuniJapan
228IwatsukiJapan
229IzumisanoJapan
253KakamigaharaJapan
256KamakuraJapan
260KanazawaJapan
276KoriyamaJapan
284KurashikiJapan
287KuwanaJapan
330MatsueJapan
337MiyakonojoJapan
354NagareyamaJapan
375OkayamaJapan
376OkinawaJapan
379OmiyaJapan
381OnomichiJapan
385OtsuJapan
439SagamiharaJapan
462SaseboJapan
473ShimonosekiJapan
520TamaJapan
546TsuyamaJapan
551UedaJapan
554UrawaJapan
401PavlodarKazakstan
597ZhezqazghanKazakstan
271KisumuKenya
371NyeriKenya
233Jalib al-ShuyukhKuwait
137DaugavpilsLatvia
303LiepajaLatvia
559VaduzLiechtenstein
569VilniusLithuania
318MahajangaMadagascar
304LilongweMalawi
223IpohMalaysia
282KuchingMalaysia
506Sungai PetaniMalaysia
4AcuaMexico
19AllendeMexico
40AtlixcoMexico
103CarmenMexico
106CelayaMexico
124Coacalco de BerriozbalMexico
125CoatzacoalcosMexico
129CuauhtmocMexico
130CuautlaMexico
131CuernavacaMexico
154El FuerteMexico
188GuadalajaraMexico
202HidalgoMexico
212Huejutla de ReyesMexico
213HuixquilucanMexico
246Jos AzuetaMexico
250JurezMexico
288La PazMexico
329MatamorosMexico
334MexicaliMexico
340MonclovaMexico
364NezahualcyotlMexico
392Pachuca de SotoMexico
444SalamancaMexico
450San Felipe del ProgresoMexico
451San Juan Bautista TuxtepecMexico
540TorrenMexico
555UruapanMexico
562Valle de SantiagoMexico
594ZapopanMexico
115ChisinauMoldova
68Beni-MellalMorocco
352NadorMorocco
442SalMorocco
64BeiraMozambique
350Naala-PortoMozambique
533TeteMozambique
341MonywaMyanmar
348MyingyanMyanmar
582YangorNauru
81BirgunjNepal
23AmersfoortNetherlands
29ApeldoornNetherlands
151EdeNetherlands
158EmmenNetherlands
437s-HertogenboschNetherlands
200HamiltonNew Zealand
69Benin CityNigeria
141Deba HabeNigeria
152Effon-AlaiyeNigeria
217IfeNigeria
218IkerreNigeria
220IlorinNigeria
252KadunaNigeria
373OgbomoshoNigeria
380OndoNigeria
388OwoNigeria
389OyoNigeria
487SokotoNigeria
595ZariaNigeria
419PyongyangNorth Korea
328MasqatOman
443SalalaOman
134DaduPakistan
323Mandi BahauddinPakistan
326MardanPakistan
374OkaraPakistan
471ShikarpurPakistan
37AsuncinParaguay
122Ciudad del EsteParaguay
452San LorenzoParaguay
99CallaoPeru
214HunucoPeru
305LimaPeru
502SullanaPeru
61BaybayPhilippines
62BayuganPhilippines
82BisligPhilippines
98CabuyaoPhilippines
104CavitePhilippines
138DavaoPhilippines
182GingoogPhilippines
192HagonoyPhilippines
219IliganPhilippines
221ImusPhilippines
294Lapu-LapuPhilippines
322MandaluyongPhilippines
390OzamisPhilippines
457Santa RosaPhilippines
516TaguigPhilippines
518TalaveraPhilippines
522TanauanPhilippines
526TanzaPhilippines
527TarlacPhilippines
547TuguegaraoPhilippines
97BydgoszczPoland
133CzestochowaPoland
236Jastrzebie-ZdrjPoland
255KaliszPoland
313LublinPoland
408PlockPoland
548TychyPoland
576WroclawPoland
32AreciboPuerto Rico
410PoncePuerto Rico
86BotosaniRomania
95BucurestiRomania
441Saint-DenisRunion
39AtinskRussian Federation
49BalaihaRussian Federation
150DzerzinskRussian Federation
156ElistaRussian Federation
225IvanovoRussian Federation
235JaroslavlRussian Federation
238JeletsRussian Federation
254KaliningradRussian Federation
259KamyinRussian Federation
270Kirovo-TepetskRussian Federation
274KolpinoRussian Federation
278KorolevRussian Federation
285KurganRussian Federation
286KurskRussian Federation
308LipetskRussian Federation
310LjubertsyRussian Federation
319MaikopRussian Federation
342MoscowRussian Federation
351Nabereznyje TelnyRussian Federation
366NiznekamskRussian Federation
368NovoterkasskRussian Federation
407PjatigorskRussian Federation
465SerpuhovRussian Federation
483SmolenskRussian Federation
509SyktyvkarRussian Federation
530TeboksaryRussian Federation
557Usolje-SibirskojeRussian Federation
596ZeleznogorskRussian Federation
269KingstownSaint Vincent and the Grenadines
2AbhaSaudi Arabia
13al-HawiyaSaudi Arabia
16al-QatifSaudi Arabia
237JeddaSaudi Arabia
514TabukSaudi Arabia
599ZiguinchorSenegal
90BratislavaSlovakia
85BoksburgSouth Africa
87BotshabeloSouth Africa
112ChatsworthSouth Africa
244JohannesburgSouth Africa
267KimberleySouth Africa
273KlerksdorpSouth Africa
363NewcastleSouth Africa
391PaarlSouth Africa
436RustenburgSouth Africa
490SoshanguveSouth Africa
496SpringsSouth Africa
113ChejuSouth Korea
268KimchonSouth Korea
356NajuSouth Korea
538TonghaeSouth Korea
552UijongbuSouth Korea
1A Corua (La Corua)Spain
146Donostia-San SebastinSpain
181GijnSpain
387Ourense (Orense)Spain
458Santiago de CompostelaSpain
230JaffnaSri Lanka
15al-QadarifSudan
378OmdurmanSudan
320MalmSweden
56BaselSwitzerland
72BernSwitzerland
296LausanneSwitzerland
108ChanghwaTaiwan
114ChiayiTaiwan
116ChunghoTaiwan
168FengshanTaiwan
209HsichuhTaiwan
315LungtanTaiwan
360NantouTaiwan
525TanshuiTaiwan
541TouliuTaiwan
545TsaotunTaiwan
346MwanzaTanzania
512TaboraTanzania
592ZanzibarTanzania
357Nakhon SawanThailand
393Pak KretThailand
488SongkhlaThailand
369NukualofaTonga
491SousseTunisia
5AdanaTurkey
50BalikesirTurkey
58BatmanTurkey
142DenizliTurkey
163EskisehirTurkey
180GaziantepTurkey
222IneglTurkey
266KilisTurkey
281KtahyaTurkey
383OsmaniyeTurkey
481SivasTurkey
503SultanbeyliTurkey
528TarsusTurkey
537TokatTurkey
556UsakTurkey
35AshgabatTurkmenistan
173FunafutiTuvalu
258Kamjanets-PodilskyiUkraine
275KonotopUkraine
344MukateveUkraine
384ostkaUkraine
478SimferopolUkraine
505SumyUkraine
3Abu DhabiUnited Arab Emirates
12al-AynUnited Arab Emirates
469SharjaUnited Arab Emirates
88BradfordUnited Kingdom
149DundeeUnited Kingdom
312LondonUnited Kingdom
493SouthamptonUnited Kingdom
494Southend-on-SeaUnited Kingdom
495SouthportUnited Kingdom
499StockportUnited Kingdom
588YorkUnited Kingdom
11AkronUnited States
33ArlingtonUnited States
41Augusta-Richmond CountyUnited States
42AuroraUnited States
65BellevueUnited States
94BrocktonUnited States
101Cape CoralUnited States
120Citrus HeightsUnited States
123ClarksvilleUnited States
126ComptonUnited States
135DallasUnited States
140DaytonUnited States
155El MonteUnited States
171FontanaUnited States
177Garden GroveUnited States
178GarlandUnited States
185Grand PrairieUnited States
187GreensboroUnited States
245JolietUnited States
262Kansas CityUnited States
292LancasterUnited States
295LaredoUnited States
306LincolnUnited States
321ManchesterUnited States
332MemphisUnited States
403PeoriaUnited States
432RoanokeUnited States
434RockfordUnited States
440Saint LouisUnited States
445SalinasUnited States
448San BernardinoUnited States
498Sterling HeightsUnited States
507SunnyvaleUnited States
519TallahasseeUnited States
572WarrenUnited States
600TexasUnited States
55BarcelonaVenezuela
102CaracasVenezuela
132CumanVenezuela
325MaracaboVenezuela
372Ocumare del TuyVenezuela
560ValenciaVenezuela
561Valle de la PascuaVenezuela
100Cam RanhVietnam
194HaiphongVietnam
201HanoiVietnam
358Nam DinhVietnam
365Nha TrangVietnam
570VinhVietnam
111Charlotte AmalieVirgin Islands U.S.
7AdenYemen
206HodeidaYemen
454SanaaYemen
517TaizzYemen
280KragujevacYugoslavia
367Novi SadYugoslavia
272KitweZambia