mysql JOIN中的IF语句-添加多个if条件成功

Question

情况是这样的：

我想加入两张桌子。比方说表a和b

SELECT * 
FROM a 
JOIN b ON a.id = b.id AND b.status = '1' 

以下是问题所在：

b.status = '1'

应仅在以下情况下添加

b.stage in (1, 3, 5, 6, 8)

如何在ON子句中添加这样的条件？

喜欢

ON a.id = b.id 
CASE
   IF (b.stage in (1, 3, 5, 6, 8))
THEN
   AND b.status = '1'
END

Answer 1

您的条件在逻辑上与“任一阶段不在列表中或状态为1”相同：

SELECT * 
FROM a 
JOIN b ON a.id = b.id 
    AND (b.stage not in (1, 3, 5, 6, 8) OR b.status = '1')