cannot recognize input near 'select' in subquery
<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>