在这里输入图片描述大家好我在这里有样品表
我正在使用此查询:
SELECT
PART_NUMBER, DATE, [WH-IN], [WH-OUT], [END-BAL]
FROM
TABLE1
WHERE
PART_NUMBER = 'TR131305R'
AND DATE <= '2016-05-30'
AND [WH-IN] = 'W1'
OR [WH-OUT] = 'W1'
问题在于它还获取了比日期更大的记录2016-05-30
问题在于您的OR
语句,它将获取遵守此子句的所有记录:
PART_NUMBER = 'TR131305R'
and DATE <= '2016-05-30'
and [WH-IN] = 'W1'
或任何符合条件的记录:
OR [WH-OUT] = 'W1'
用括号将其修复:
SELECT PART_NUMBER, DATE, [WH-IN], [WH-OUT], [END-BAL]
FROM TABLE1
WHERE PART_NUMBER = 'TR131305R'
and DATE <= '2016-05-30'
and ([WH-IN] = 'W1' --wrap this clause in ()
or [WH-OUT] = 'W1')
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句