title: how to write multiple select queries in single procedure?
body: <p>I have to tables as:
  table1:</p>
  
  <pre><code>UID | COLLEGE_NAME | COLLEGE_ADDRESS
  ------------------------------------
  </code></pre>
  
  <p>table2:</p>
  
  <pre><code>UID | COMPANY_NAME | COMPANY_ADDRESS
  ------------------------------------
  </code></pre>
  
  <p>i have 2 queries:</p>
  
  <pre><code>select * from table1 where uid='$uid';   
  select * from table2 where uid='$uid';
  </code></pre>
  
  <p>i want to write this two queries in one procedure. </p>