title: Best Approach To Handle Multiple Select Statements In A Single Trip To The Database
body: <p>I am thinking a transaction would help me in the following example but I could be wrong. What I am attempting to avoid is making 3 different calls to the database if I dont have too in the following scenerio..</p>
  
  <p>I want to do the following:</p>
  
  <ol>
  <li>select name, address from employee</li>
  <li>select state from states</li>
  <li>select error from errorTable</li>
  </ol>
  
  <p>In this case I have to call several different selects to get data. What is the best way to approach this scenerio to return all the data I want to read minimizing several calls to the database? </p>
  
  <p>Note: No tables have a relationship between them.</p>