title: MySQL Stored Procedure with Multiple Select statements From Different Tables
body: <p>I'm trying to do multiple selects from different tables in a mysql stored procedure as follows </p>
  
  <pre><code>DELIMITER //  
  CREATE PROCEDURE `NovemberSummary`(IN `branch` VARCHAR(60), IN `year` INT) NOT 
  DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER 
  BEGIN
  select sum(sales.amount) as Sales from sales where month (sales.date)= 11 and 
  sales.branch = branch;
  select sum(expenses.amount) as Expenses from expenses where month(expenses.date)= 11
  and expenses.branch = branch;
  END
  </code></pre>
  
  <p>But It returns only The first Select, as In result set only contains Sales Column.</p>
  
  <p>MySQL Version is 5.6.11 - MySQL Community Server</p>