 | | | Query multiple tables | Query multiple tables 2006-07-02 - By Peter Brawley
Back
>What query do I need to get
>AccommodationName and what attractions it has from
AccommodationAttractions
SELECT
ac.accommodationname,
at.attractionname
aa.AccomodationAttraction
FROM
accommodationattractions AS aa
INNER JOIN accommodations AS ac USING (accommodationid)
INNER JOIN attractions AS at USING (attractionid);
PB
-- --
Neil Tompkins wrote:
> 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
>
>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|