Results 1 to 13 of 13
Thread: Help with SQL query syntax
Jun 16, 2013, 01:24 #1
- Join Date
- Dec 2011
- 0 Post(s)
- 0 Thread(s)
Help with SQL query syntax
Just looking for a bit of help with an SQL query.
The table structure is:
ItineraryID, Itinerary, etc
ActivityID, Activity, etc
And an interlinking table
And I have a page here, listing Itineraries:
That I would like to include some of the Activities on.
If it was just the first two tables, and tableActivities had an ItineraryID field, I assume it would be:
SELECT * FROM Itineraries INNER JOIN Activities ON Itineraries.ItineraryID = Activities.ItineraryID
But I'm not sure what the syntax would be to achive the same thing with the interlinking table as well.
Hope that makes sense.