title: IF Statement Query Syntax Error
body: <p>I am trying to replace a <code>foreach</code> statement with a single SQL query, my code I want to change looks like this:</p>
  
  <pre><code> this.Settings = new List&lt;Setting&gt;()
          {
              // Write all the settings from the VB
              new Setting() { Name = "NOOFORDERS", Value = null },
              new Setting() { Name = "ORDNVGREQ", Value = null },
              new Setting() { Name = "IncWendsDel", Value = null },
              new Setting() { Name = "AUTOEMAIL_INVOICE", Value = null },
              new Setting() { Name = "REQEMAIL_INVOICE", Value = null },
              new Setting() { Name = "REQEMAIL_SALES", Value = null },
              new Setting() { Name = "REQEMAIL_PICKSLIP", Value = null },
              new Setting() { Name = "REQEMAIL_DESPATCH", Value = null },
              new Setting() { Name = "CARRPARTSHIP", Value = null },
              new Setting() { Name = "DELNOTEREQ", Value = null },
              new Setting() { Name = "REQ_CARRPARTSHIP", Value = null },
              new Setting() { Name = "BUDGETREQ", Value = null },
              new Setting() { Name = "PriceList", Value = null },
              new Setting() { Name = "EmployeeRenew", Value = null },
              new Setting() { Name = "Warehouse", Value = null },
              new Setting() { Name = "EmployeeDetails", Value = null },
          };
  var value = this.db.tblbus_setvalues.Where( x =&gt; x.SettingID == setting.Name &amp;&amp; x.BusinessCode == this.Business.BusinessCode ).FirstOrDefault().Value;
  switch (value.GetType())
  {
      case typeof(bool):
          (value) ? setting.Value = "true" : setting.Value = "false";
          break;
      default:
          setting.Value = value.ToString();
          break;
      }
      if ( !string.IsNullOrEmpty(setting.Value) ) setting.Value = this.db.tblbus_settings.Where( x =&gt; x.SettingID == setting.Name ).FirstOrDefault().Default.ToString();
  </code></pre>
  
  <p>My SQL which I want to replace the above code with looks like this:</p>
  
  <pre><code>SELECT t1.SettingID, t2.Value, t1.Default
  FROM `tblbus_settings` t1
  LEFT JOIN `tblbus_setvalues` t2
  ON t1.SettingID = t2.SettingID
  WHERE `BusinessCode` = "XXX" // Dependency
  AND t1.`BusType` = "CUS"
  </code></pre>
  
  <p>Can anyone help me write an IF statement onto this SQL query which will only display the <code>t2.Value</code> if the <code>t1.Default</code> is <strong>null</strong>?</p>
  
  <p>I tried things like:</p>
  
  <pre><code>IF(t2.value == NULL) { t1.Default }
  ELSE { t2.Value }
  </code></pre>
  
  <p>But they all give me SQL syntax errors.</p>