Archives of the TeradataForum

Message Posted: Sat, 07 Feb 2009 @ 08:46:55 GMT

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

What you have here should work!

I just copied and pasted your NOT IN clause into this SQL in SQL Assistant and ran it, and it worked.

     sel * from dbc.qrylog where querytext  not in (
     'SELECT InfoData FROM dbc.dbcinfo where InfoKey =''release'''
     ) ;

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