title: SQL Server: if 2 columns have a specific value then return a third column
body: <p>I am trying to create a SQL query that does the following.</p>
  
  <pre><code>If (field-A = Value1) and (field-B = value1)
  then (field-c)
  </code></pre>
  
  <p>So if 2 columns have a certain value I want to return the value of a third column.</p>