title: How to select multiple columns with 1 column with count
body: <p>I have two tables namely tbl_votes and tbl_candidates:</p>
  
  <p>tbl_votes: contains the ff column:</p>
  
  <pre><code>voteID    president    vicePresident    secretary    treasurer    rep1    rep2     rep3
  1             1              3                                     9       12       15
  2             1              4              6            8         12      15
  3             2              3              5            7         9       12
  </code></pre>
  
  <p>while tbl_candidates contain the ff column:</p>
  
  <pre><code>idcandidate  fName         mName         lName         position
  1            Jefferson     Garcia        Roxas         president
  2            Carlson       Mcvoy         Zafiro        president
  3            Andrew        Efron         Anderson      vice president
  4            Jessica       Garcia        Roxas         secretary
  </code></pre>
  
  <p>...</p>
  
  <pre><code>9            Jayson        Sanchez       Dela Cruz      representative
  10           Arille Alisa  Villanueva    Valdez         representative
  11           Arnold        Castro        Baltazar       representative
  12           Kristina      de Leon       Guillermo      representative
  13           Jayson        Jones         Dela Cruz      representative
  14           Karla         Santos        Abrogena       representative
  15           Jason                       Chua           representative
  </code></pre>
  
  <p>The query that I want to is:</p>
  
  <pre><code>Name                                                       votes
  Jefferson Garcia Roxas                                       2
  Carlson Mcvoy Zafiro                                         1
  Andrew Efron Anderson                                        2
  Jessica Garcia Roxas                                         1
  </code></pre>
  
  <p>...</p>
  
  <pre><code>Jayson Sanchez Dela Cruz                                     2
  Arnold Castro Baltazar                                       0
  Kristina de Leon Guillermo                                   3
  Jason  Chua                                                  2
  </code></pre>
  
  <p>I'm stuck where to count the votes and here is my codes:</p>
  
  <pre><code>SELECT `Name`, Votes
  FROM (SELECT COUNT(*) as Votes FROM tbl_votes) a
  CROSS JOIN (Select (Concat(fName ,' ',mName,' ', lName)) as `Name` from tbl_candidates) b;
  </code></pre>
  
  <p>the result of this query is:</p>
  
  <pre><code>Name                                                       Votes
  Jefferson Garcia Roxas                                       3
  Carlson Mcvoy Zafiro                                         3
  Andrew Efron Anderson                                        3
  Jessica Garcia Roxas                                         3
  Jayson Sanchez Dela Cruz                                     3
  Arnold Castro Baltazar                                       3
  Kristina de Leon Guillermo                                   3
  Jason  Chua                                                  3
  </code></pre>
  
  <p>How will i make the count specific to the idcandidate?
  Your great help will be much appreciated. Thank you!</p>