Archives of the TeradataForum

Message Posted: Mon, 24 Sep 2012 @ 12:54:03 GMT

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

< -- Anonymously Posted: Monday, September 24, 2012 06:31 -- >

Use below logic and get teh answer...

     sel * from tab1 a
     where not exists ( sel 'x' from tab1 b
                          where a.enum = b.enum
                          and b.enum = 100
                          and b.eval = 1
                      )

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