Jason,
I made it :-)
SELECT DISTINCT
`profile`.profileID,
`profile`.`name`,
`profile`.plz,
`profile`.city,
GROUP_CONCAT(DISTINCT genre.genre) AS genre,
GROUP_CONCAT(DISTINCT instrument.instrument) AS instrument
FROM
`profile`
INNER JOIN profilegenre ON `profile`.profileID = profilegenre.profileID
INNER JOIN profileinstruments ON `profile`.profileID = profileinstruments.profileID
INNER JOIN genre ON genre.genreID = profilegenre.genreID
INNER JOIN instrument ON instrument.instrumentID = profileinstruments.instrumentID
GROUP BY
`profile`.profileID
ORDER BY
`profile`.plz ASC
Cause I got the instrumentID field double, I needed to customize the DA search wizard into profileinstrument.instrumentID :-)
I am so happy that it works!
thanks for your help!
denis
ps. maybe in DA update it would be cool that it automatic choose the right table :-)