Archives of the TeradataForum

Message Posted: Wed, 18 Nov 2009 @ 10:03:47 GMT

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

Anomy,

When you execute the SQL against the 4 views, are you qualifying the database names? It is possible that unqualified view references are defaulting to your 'default database' as opposed to the view (which would default any unqualified views with the default database associated with the user that created the view.)

It would help to see the SQL and view DDL.

Thanks,

Clay

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