| 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 tables | Neil Tompkins | 2 Jul |
| • Re: Query multiple tables | Peter Brawley | 2 Jul |