DISTINKT-Befehl

[Oliver Lehmann]

Hi,

versuchs mal mit (ungetestet)
$sql_query_6 = "SELECT DISTINCT s.id, s.name, s.adresse FROM shops s, bezirke b, shop_bez sb WHERE b.stadt='$stadt' AND s.kat='s' AND sb.rest=s.id AND sb.bez=b.id GROUP BY s.name ORDER BY sb.pos";

s.name muessen natuerlich 100% identisch sein

MfG Olli