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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
