title: Combine two sql query
body: <p>can someone help me combine this two sql query to have the result of the first query into a column of the second one , thank you </p>
  
  <pre><code>SELECT
      `c`.`backoffice_users_id`,
      sum(c.nbr_sous_risques) AS `nbr_sous_risques`
  FROM `conseillers_sous_risques` AS `c`
  WHERE
      (c.date_du_jour='2013-11-10')
      AND (c.idsous_risques BETWEEN 1 AND 12)
  GROUP BY `c`.`backoffice_users_id`
  
  
  SELECT
      `c`.`backoffice_users_id`,
      `c`.`idsous_risques`,
      `c`.`nbr_sous_risques`,
      `backoffice_users`.`lastname`
  FROM `conseillers_sous_risques` AS `c`
  INNER JOIN `backoffice_users` ON c.backoffice_users_id=backoffice_users.id
  WHERE (c.date_du_jour='2013-11-10')
  ORDER BY
      `c`.`backoffice_users_id` ASC,
      `c`.`idsous_risques` ASC
  </code></pre>