List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:July 2 2006 9:15am
Subject:Query multiple tables
View as plain text  
Hi,

How do I query multiple tables.  For example I have

TableName      Accommodation
Field1             AccommodationID
Field2             AccommodationName

I also have

TableName     Attractions
Field1            AttractionID
Field2           AttractionName
Field3           AttractionDescription

Then I have

TableName     AccommodationAttractions
Field1            AccommodationAttractions
Field2           AccommodationID
Field3           AttractionID

What query do I need to get

AccommodationName and what attractions it has from AccommodationAttractions

Thanks
Neil


Thread
Query multiple tablesNeil Tompkins2 Jul
  • Re: Query multiple tablesPeter Brawley2 Jul