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

List of a country's embassies worldwide

 
#qembassyhostcountry.country#