title: Multiple Case statements in SQL
body: <p>I've got a basic one for you. I have the syntax broken on the following statement. I don't know how to run two 'case' selects in one statement. I am getting the error: FROM keyword not found where expected.</p>
  
  <pre><code>SELECT
      CASE
          WHEN`enter code here`
              attr.UDA_AUTO_KEY = 40
                  THEN
                      'Parts Sales'
          ELSE
              'This is blank'
      END AS Parts Sales,
      CASE
          WHEN
              attr.UDA_AUTO_KEY = 5
                  THEN
                      'Aircraft Management'
          ELSE
              'This is blank'
      END AS Aircraft Management,
      cmp.COMPANY_NAME, cmp.ADDRESS1
  FROM COMPANIES cmp
  LEFT JOIN UDA_CHECKED uda ON uda.AUTO_KEY = cmp.CMP_AUTO_KEY
  LEFT JOIN USER_DEFINED_ATTRIBUTES attr ON uda.UDA_AUTO_KEY = attr.UDA_AUTO_KEY
  WHERE attr.AUTO_KEY_PREFIX = 'CMP'
  </code></pre>