Just looking for a bit of help with an SQL query.

The table structure is:

table.Itineraries
ItineraryID, Itinerary, etc

table.Activities
ActivityID, Activity, etc

And an interlinking table

table.ItineraryActivities
ItineraryID, ActivityID

And I have a page here, listing Itineraries:

http://www.goodsafariguide.net/itine...a/index101.php

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.

Thanks.