n:m beziehung

[Ilja]

yo,

SELECT DISTINCT a.id_anbieter, a.name
FROM location l
INNER JOIN location_anbieter la ON la.id_location = l.id_location
INNER JOIN anbieter a ON a.id_anbieter = la.id_anbieter
WHERE l.pls = 'hier_pls_angeben'
;

Ilja