If you know the total number of amenities, n, then you could try this:
SELECT h.ID, count(*) as total
FROM AmenityLink al, Hotels h
where al.HotelID=h.ID
AND ShowHotel = 1
AND PostCode = '$postcode'
group by h.ID
having total=n
Hope it helps.
Cheers,
Clemente Zamora
GlobalReservas
(http://www.c
> -Original Message-
> From: Chris Mason [mailto:masonc@;masonc.com]
> [...]
> The problem is, it is easy to test for one amenity, but I need to test
> that the hotel has all of the amenities. The query above
> returns all the
> hotels that have ANY of the amenities, I need the hotels hav
of course, you can get help here, but there is a
free point and click query tool listed in the
portals that may help you a lot. it lets you
quickly create queries by just pointing and
clicking, and when you get what you want, it
shows you the sql code.
i can't name it because i'll get fus
