select a.id_anbieter, a.name
from location, location_anbieter, anbieter
where la.id_location = l.id_location and a.id_anbieter = la.id_anbieter
where l.plz = 12345;  // and l.plz = 12345;

geht das