在WHERE子句中使用多个值 [英] Using multiple values in WHERE clause

问题描述

当Att.AttendMakeup和Att.AttendNoMakeup的值相同且在同一天但不是0时，我试图返回出席。



我尝试过：



WHERE（（Att.AttendMakeup> 0）=（Att.AttendNoMakeup> 0）AND DATE1 = DATE2）

I am trying to return Attendance when the values of Att.AttendMakeup and Att.AttendNoMakeup are the same and on the same date but not 0.

What I have tried:

WHERE ((Att.AttendMakeup > 0) = (Att.AttendNoMakeup > 0) AND DATE1 = DATE2)

推荐答案

当你分成不同的行时最容易阅读。

检查两者（AttendMakeup = 0）和（和Att.AttendNoMakeup = 0）因为两者必须相等。 与短路逻辑类似

Easiest to read when you split into separate lines.
It would be redundant to check if both (AttendMakeup=0) and (Att.AttendNoMakeup=0) because the both must be equal. Similiar to short-circuit logic

WHERE  (Att.AttendMakeup > 0)
AND    (Att.AttendMakeup = Att.AttendNoMakeup)
AND    (DATE1 = DATE2)

这篇关于在WHERE子句中使用多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！