title: Join two mysql queries
body: <p>I have 3 tables: </p>
  
  <p>Table1</p>
  
  <pre><code>RouteID             int
  departure_stop      int 
  destination_stop    int 
  Price               decimal(6,2) 
  </code></pre>
  
  <p>Table2</p>
  
  <pre><code>StopID          int
  Stop            varchar(50)
  Cities_CityID   int
  </code></pre>
  
  <p>Table3</p>
  
  <pre><code>CityID      int
  City        varchar(50)     
  </code></pre>
  
  <p>I want to get all Routes which are cheaper than 50. 
  I want get departure city and destination city like this</p>
  
  <pre><code>City    City
  Paris   London
  Madrid  Zagred
  </code></pre>
  
  <p>So far I have dove two queries I am getting departure city and then second query for destination city, but don't know how join them side by side. Here are my queries:</p>
  
  <pre><code>SELECT
      Cities.City
  FROM Routes, Stops, Cities
  WHERE (Stops.StopID = Routes.departure_stop AND Stops.Cities_CityID = Cities.CityID AND Routes.price &lt; '50') 
  </code></pre>
  
  <p>And</p>
  
  <pre><code>SELECT
      Cities.City
  FROM Routes, Stops, Cities
  WHERE (Stops.StopID = Routes.destination_stop AND Stops.Cities_CityID = Cities.CityID AND Routes.price &lt; '50')
  </code></pre>
  
  <p>So the question is how to join them together side by side so I could see departure and destination?</p>