title: SQL Server join using multiple columns
body: <p>I need help with joining two tables in following scenario</p>
  
  <pre><code>Table One
  Col A
  Col B
  Col C1
  Col C2
  Col C3
  
  Table Two
  Col C
  Col D
  </code></pre>
  
  <p>I need to join [One] with [Two] and get One.A and Two.D as my output.</p>
  
  <p>Here is the join logic:</p>
  
  <p>Join on [One].C1 = [Two].C if no match, I need to join [One].C2 = Two.C again if no match join with [One].C3 = [Two].C</p>