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

List of embassies located in a country worldwide

 
#qembassyhostcountry.country#