select distinct tbembassy.hostcountryID, tbcountry.countryID, tbcountry.country from tbembassy, tbcountry where tbembassy.hostcountryID = tbcountry.countryID and tbcountry.approved = 1 order by tbcountry.country select distinct tbembassy.countryID, tbcountry.countryID, tbcountry.country from tbembassy, tbcountry where tbembassy.countryID = tbcountry.countryID and tbcountry.approved = 1 order by tbcountry.country select distinct tbembassy.hostcountryID, tbembassy.countryID, tbcountry.country from tbembassy, tbcountry where tbembassy.hostcountryID = tbcountry.countryID and tbcountry.approved = 1 order by tbcountry.country



all embassies located in a country


full list of a country's embassies

...Search for a specific embassy in a country: