title: Conditional JOIN Statement SQL Server
body: <p>Is it possible to do the following:</p>
  
  <pre><code>IF [a] = 1234 THEN JOIN ON TableA 
  ELSE JOIN ON TableB
  </code></pre>
  
  <p>If so, what is the correct syntax?</p>