title: MySQL Query for Counts from Multiple Tables
body: <p>I've started a SQL Fiddle here:
  <a href="http://sqlfiddle.com/#!2/26c26/7" rel="nofollow">http://sqlfiddle.com/#!2/26c26/7</a></p>
  
  <p>You can view that sample table and see that I've got multiple car models across three tables. I'm trying to get a 6 column layout. The first two columns would be JeepMart1 models, and the count of those models, then the next two columns would the JeepMart2 models, and counts and the last two columns would be JeepMart3 models and counts. </p>
  
  <p>The results of this query from the fiddle table would look like:</p>
  
  <pre><code>Jeep1Models | Jeep1Counts | Jeep2Models | Jeep2Counts | Jeep3Models | Jeep3Counts |
  Wrangler          3         Wrangler          1  
  Grand Cherokee    2         Grand Cherokee    3         
                              Patriot           1         Patriot           5
  </code></pre>
  
  <p>The idea is to get a count of each model from each JeepMart. </p>
  
  <p>If it's at all possible, it would be the cherry on top to get the totals of each model like this: (shortened the col names for readability)</p>
  
  <pre><code>Jeep1Mod | Jeep1Cou | Jeep2Mod | Jeep2Cou | Jeep3Mod | Jeep3Cou | Totals
  Wrangler       3      Wrangler       1                               4
  Grand Cher     2      Grand Cher     3                               5
                        Patriot        1      Patriot        5         6
  </code></pre>
  
  <p>I am completely open to querying this data in another way, even if it means changing the layout of the results, as long as all the results are there, and are just as easy to use. </p>