title: Mysql many to many table queries
body: <p>I have 3 tables cars, drivers, cars_drivers. </p>
  
  <p>my cars table has two fields - carid and car_model</p>
  
  <p>my drivers table has two fields - driverid and driver_name</p>
  
  <p>my cars_drivers has two fields which are primary keys - carid and driverid.</p>
  
  <p>I have 3 entries in my cars table</p>
  
  <ol>
  <li>toyota</li>
  <li>honda</li>
  <li>kia</li>
  </ol>
  
  <p>and my  drivers table has</p>
  
  <ol>
  <li>bob</li>
  <li>tom</li>
  </ol>
  
  <p>What would my car_drivers table be like? Would I put any number 3 or less in carId and 2 or less in DriverId?</p>
  
  <pre><code>1-1
  1-2
  1-3
  </code></pre>
  
  <p>How would I make a query that will display 3 car models with random drivers?</p>
  
  <p>I'm looking for something like</p>
  
  <pre><code>toyota  bob
  kia     tom
  honda   bob
  </code></pre>
  
  <p>ive been looking through some of the tutorials and im also not following how the joins work</p>