title: Query to Find Best bus interchange Route along with list of Stops
body: <p>I have a table named route_detail which has route_ID,ROUTE_NO,STOP_ID,STOP_POSITION AS column. I have multiple route and this table stored the detail of each route. </p>
  
  <pre><code>routeNo StopID  StopPosition
  -----------------------------
  1       1256       1
  1       1245       2
  1       1255       3
  1       1236       4
  1       1654       5
  1       1655       6
  2       676        1
  2       1236       2
  2       678        3
  2       679        4
  3       765        1
  3       766        2
  3       768        3
  3       1236       4
  3       1278       5
  3       1290       6
  </code></pre>
  
  <p>What I want is when the START AND DESTINATION STOP ID is different (that is not on the same route, My query should be able to retrieve The Source RouteNo, Interchange Stop_ID and the Destination Route No. </p>
  
  <p>For example from above if Source Stop ID = 1256 and Users Wants to Travel to Destination StopID= 679, So the output should be </p>
  
  <pre><code>routeNo StopID  StopPosition
  -----------------------------
  1       1256       1
  1       1245       2
  1       1255       3
  1       1236       4
  2       1236       2
  2       678        3
  2       679        4
  </code></pre>
  
  <p>I am totally new to queries and joins and hence doesn't know how to make a query to retrieve this kind of result set.
  I am using mysql 5.7 with workbench</p>
  
  <p>Thanks for all your assist in advance. </p>