如果Events.Type
字段等于 1,我需要在以下查询中使用 XXXXX 的查询部分是这样的:
ON Stages.ID = Abandonments.IDstage
如果它是 2 Events.Type,带有 XXXXX 的查询部分是这样的:
ON Stages.ID > Abandonments.IDstage
询问
SELECT
*,
Events.Type
FROM Participants
INNER JOIN Times
ON Participants.ID = Times.IDparticipant
INNER JOIN Events
ON Events.ID = Participants.IDevent
AND Events.ID = Times.IDevent
INNER JOIN Stages
ON Events.ID = Stages.IDevent
AND Stages.ID = Times.IDstage
LEFT OUTER JOIN (SELECT
Retired.ID,
Retired.IDstage,
Retired.IDparticipant,
Retired.IDevent
FROM Retired) Abandonments
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
AND Participants.ID = Abandonments.IDparticipant
AND Events.ID = Abandonments.IDevent
WHERE Times.IDevent = 31
AND Times.IDstage = 156
ORDER BY Participants.ID
谢谢
您的 SQL 查询中有很多内容X
,并且没有显示您尝试构建的限定符,因此我不太清楚您在这里尝试达到的意图。
但是,您在问题中描述了解决方案。
因此:
ON ((Stages.ID = Abandonments.IDstage AND Events.Type = 1) OR
(Stages.ID > Abandonments.IDstage AND Events.Type = 2))
如果这些定义的参数都不为真(比如说Events.Type = 3
),那么你需要添加一个限定符或一个假返回来排除这个整体JOIN
ON ((Stages.ID = Abandonments.IDstage AND Events.Type = 1) OR
(Stages.ID > Abandonments.IDstage AND Events.Type = 2)) OR 2=1
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句