Archives of the TeradataForum

Message Posted: Wed, 28 Feb 2007 @ 23:32:53 GMT

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

how about this?

     select databasename, tablename
     from dbc.columns
     where columnname in ('art_no','client_cd')
     having count(*) = 2
     order by 1,2
     ;

Ulrich

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