title: create select statement based on case statement in sql
body: <p>Is there a clean way in sql to create a select statement based on a case statement? </p>
  
  <p>I'm looking for the basic logic to be something like </p>
  
  <pre><code>   CASE @tableToUse
             WHEN 'Table1' SELECT * FROM Table1 
             WHEN 'Table2' SELECT * FROM table2 
             DEFAULT 'Table3' SELECT * FROM table3
     END CASE
  </code></pre>