Archives of the TeradataForum

Message Posted: Mon, 10 Aug 2009 @ 15:21:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

          > Where location = 4443
          >       And unit_ID = 3124
          >       And fault=3 OR fault=35 OR fault=155 or fault=156

AND is evaluated before OR, so this is probably not what is desired. Instead, write:

     Where location = 4443
            And unit_ID = 3124
            And (fault=3 OR fault=35 OR fault=155 or fault=156)

	<Prev	Next>		<<First	<Prev	Next>	Last>>