sql - 无法在子查询中识别 'select'附近的输入

Question

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;

我试图运行上面的查询，下面的错误。
有人可以帮忙吗？

失败:ParseException行4:1无法识别表达式规范中'select''economic_tactic_id''from'附近的输入

Answer 1

尝试使用

SELECT (case TRIM(T.tactictype) WHEN 'Economics' THEN (select E.economic_tactic_id from cfext.economic_tactics E 
    where LOWER(E.economic_tactic_name) = LOWER(T.tacticname) ) 
WHEN 'Cyber' THEN (select E.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;