title: SQL double SELECT on the same field (mysql or sqlite3)
body: <p>i have a problem that i can't solve ! (sqlite3, but i think it would be the same than MySql)
  I have those tables (image) :</p>
  
  <p><a href="http://www.radarkiller.fr/blog/bddprobleme.png" rel="nofollow noreferrer">alt text http://www.radarkiller.fr/blog/bddprobleme.png</a></p>
  
  <p>And i would like to find all the bus lines (with type and number) that go to two different streets from which i have the street_id (12 and 14 for exemple).</p>
  
  <p>The result shall give to the customer all of the bus lines (the id, type and number) in the city which go from the street n°12 to the street n°14 (example).</p>
  
  <p>Like Larry Lustig said you can make a shortcut with the two neighborhood foreign keys.</p>
  
  <p>Thank you in advance for your help !</p>