IS IN (Select语句，'value'，'value')

Question

我正在尝试运行以下SQL

DELETE FROM T_ATH_POSHLD WHERE T_ATH_POSHLD.A_INSID IN (SELECT T_ATH_POSHLD.A_INSID FROM T_ATH_POSHLD LEFT JOIN T_ATH_INS ON T_ATH_POSHLD.A_INSID = T_ATH_INS.A_INSID WHERE T_ATH_INS.A_INSCLSCDE1 = 'CASH' AND T_ATH_POSHLD.A_INSID NOT IN (SELECT A_INSID FROM T_ATH_CCY) AND A_ACCID IN (SELECT A_ACCID FROM T_ATH_EXTACC, '1212OEIC', '5667033ZS'))

特别是，我尝试检查ACCID是否在一组值中，其中一些值来自一个表，两个值是硬编码的。我将如何实现这一点？

IN (SELECT A_ACCID FROM T_ATH_EXTACC, '1212OEIC', '5667033ZS')

不工作，我得到一个‘不正确的语法错误’。

谢谢

Answer 1

您需要使用UNION将两个硬编码值添加到要传递给in子句的结果集中。

IN (SELECT A_ACCID FROM T_ATH_EXTACC UNION ALL SELECT '1212OEIC' UNION ALL SELECT '5667033ZS')

Answer 2

IN (SELECT '1212OEIC', '5667033ZS', A_ACCID FROM T_ATH_EXTACC )