I have 2 tables,
1 called journeys, which contains the journeyID, the start station, end station, time to complete, and the distance. The second table is called connections and contains all the stations the train stops at along the journey. I need to write a query which extracts the correct journey based on 2 connection points/stationID's...
Anyone have any idea how to do this?
I want journey ID based on station ID's in connection point table where both connections are present in the connection point for that journey.