Archives of the TeradataForum
Message Posted: Thu, 24 Jan 2008 @ 11:23:52 GMT
For what it's worth, whenever this type of confusing arises here at TNT I always recommend starting off with reversing the logic, egSELECT Something OR Other FROM Howsyourfather;
and then apply the NOT to that :SELECT NOT(Something OR Other) FROM Howsyourfather;
Honestly, it makes complex OR's and AND's a lot easier to code.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|