rvas
(http://www.clementezamora.com)
"Chris Mason" <[EMAIL PROTECTED]> wrote:
>
> Asunto: Need a little query help
> Fecha: Mon, 28 Oct 2002 08:08:41 -0400
> De: "Chris Mason" <[EMAIL PROTECTED]>
> A: <[EMAIL PROTECTED]>
>
> I am tryin
> -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
I am trying to select some data from a hotel database I am putting on
the web. Currently I am using two temporary tables and three queries to
get the data, but I suspect it can be done in one query by a better
knowledge of SQL.
The tables are
Hotels:
ID,
PostCode,
ShowHotel
AmenityLink:
ID,
Hotel