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
Thank you very much.
Works perfectly now.
-Ursprüngliche Nachricht-
Von: Harald Fuchs [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 15. Juli 2004 13:58
An: [EMAIL PROTECTED]
Betreff: Re: query w multiple tables and expressions
This gives all hotels having at least one of the required
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
Hello everyone
I hope this is the right list for my question if not please let me know.
First I've got to say that I'm not an experienced "query-builder" so maybe
the answer to my problem is very easy. But I have no idea how I could solve
this problem and all my research (Internet and Forums) did
