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

ItineraryID, ActivityID

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.