[AccessD] Back to Front

Thanks Jeffery, I now have the query working with a LEFT JOIN Hotels
Martin

----- Original Message -----
From: <jeffrey.demulling at usbank.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, March 05, 2005 8:14 AM
Subject: Re: [AccessD] Back to Front


> try this, not tested, just off the top of my head...
>
> SELECT
> HotelName
> FROM
> OWNERS
> JOIN HOTELS
> ON OWNERS.HotelID = HOTELS.HotelID
> WHERE
> OWNERS.OwnerID = <<value Here>>
>
> Jeffrey F. Demulling
> Project Manager
> U.S. Bank Corporate Trust Services
> 60 Livingston Avenue
> EP-MN-WS3C
> St. Paul, MN  55107-2292
> Ph: 651-495-3925
> Fax: 651-495-8103
> email: jeffrey.demulling at usbank.com
>
>
>
>              "Martin Caro"
>              <mcaro at bigpond.ne
>              t.au>                                                      To
>              Sent by:                  "Access Developers discussion and
>              accessd-bounces at d         problem solving"
>              atabaseadvisors.c         <accessd at databaseadvisors.com>
>              om                                                         cc
>
>                                                                    Subject
>              03/04/2005 03:01          [AccessD] Back to Front
>              PM
>
>
>              Please respond to
>                   "Access
>                 Developers
>               discussion and
>              problem solving"
>              <accessd at database
>                advisors.com>
>
>
>
>
>
>
> Hi folks
> What's the simplest way to do the following...
> I have a table of hotels 1:M with a table of owners. (HotelID is my
> primary/foreign key)
> I want to select an owner from the owner table and for as many times as
> that owner appears in the child table, list (in a subform), the related
> hotels in the parent table.
> I'm OK with the mechanics its just that it's back to front from normal and
> it's the wrong end of the week (recursion?).
>
> Ta
> Martin
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
> --------------------------------------------------------------------------
----
> Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank
you in advance for your cooperation.
>
============================================================================
==
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>