Hi all,
I've got 2 tables as below:
stops
Stop_name
RouteNumb
Order
Min_from_start
routes
RouteNumb
Start_time
In essence, Start_time contains the time the bus sets out on its journey, and Min_from_start is how many minutes from the first stop the bus is (eg. so if Start_time is 09:00 and Min_from_start is 14, then I'm looking for 09:14).
Can anyone please help me find an SQL query to calculate this?
So far I've got
SELECT stops.Stop_name, stops.Min_from_start, routes.Start_time
FROM routes INNER JOIN stops ON Routes.RouteNumb = stops.route
WHERE (((stops.route)="12"));
Which shows the info but not the times.
Thank you so much!