Archives of the TeradataForum

Message Posted: Thu, 21 May 2009 @ 21:58:09 GMT

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

<-- Anonymously Posted: Thursday, May 21, 2009 17:54 -->

Names don't matter. Data types do.

First change the * to the lists of column names.

If there is still an issue, look at corresponding DDL or use TYPE(columnname) attribute function to query. You will find a mismatch - something in the first list which doesn't match the corresponding entry in the second list, AND there is no implicit conversion available from the type in the second list to the type in the first list.

Sometimes you may need to CAST the columns in the first list to a conforming type or supertype.

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