Archives of the TeradataForum

Message Posted: Wed, 19 Jun 2013 @ 12:35:33 GMT

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

Try below one.( its based on the data in the dbc.logonoff)

     Select username from dbc.users
     Minus
     Select username from dbc.logonoff group by 1

Thanks,

Mahesh

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