title: cannot recognize input near 'select' in subquery
body: <pre><code>SELECT 
      (case TRIM(T.tactictype)
          WHEN  'Economics' THEN
              (select economic_tactic_id from cfext.economic_tactics E where LOWER(E.economic_tactic_name) = LOWER(T.tacticname) )
          WHEN  'Cyber' THEN
              (select cyber_tactic_id from cfext.cyber_tactics E where LOWER(E.cyber_tactic_name) = LOWER(T.tacticname) )
      end) AS tacticid 
  FROM cfext.banking_crreport_allfiles T
  LIMIT 50;
  </code></pre>
  
  <p>I am trying to run the above query, below error.
  Can anybody please help.</p>
  
  <p>FAILED: ParseException line 4:1 cannot recognize input near 'select' 'economic_tactic_id' 'from' in expression specification</p>