You almost had it right, your FINAL "AND" was blowing your syntax. You are
not really aggregating anything so you also do not need the GROUP BY
clause, Your ORDER BY clause should keep all of the hotels listed for you
.
SELECT *
FROM stammdaten
INNER JOIN relation_services ON stammdaten.id_P
In article <[EMAIL PROTECTED]>,
Salzgeber Olivier <[EMAIL PROTECTED]> writes:
> I need to create a search Query to find all the hotels which have specific
> services and sparetime activities.
> For example:
> Search for hotels where location is "Bern" and the hotel has sparetime
> activity 2 and
