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.