FIND A HEARING CENTRE

SELECT DISTINCT City.City, City.CityId, City.CountryId FROM Dispenser INNER JOIN City ON City.Cityid = Dispenser.NCity WHERE City.Countryid=0 and Dispenser.Online <> 0 order by City.City