SQL - 围绕 AND 的 IF 语句

Question

我正在尝试创建一个查询，该查询只会在满足某些条件的情况下添加 AND 子句。

这就是我所追求的:

SELECT DISTINCT
  id
  name
  active
FROM team
WHERE id = 1234
IF team.active = 'y'
  AND team.id IN
    {
       query
    }
ELSEIF team.active = 'n'
  AND team.id IN
    {
      query
    }

但我不确定如何在 SQL 中执行此操作。有什么建议？

Answer 1

 SELECT DISTINCT
    id
    name
    active
    FROM team
 WHERE id = 1234
   AND (team.active = 'y'
     AND team.id IN
        {
          query
        }) 
   OR
    (team.active = 'n'
     AND team.id IN
      {
        query
      })

您使用 AND 和 OR 连接词来创建逻辑。