Archives of the TeradataForum

Message Posted: Tue, 28 Feb 2006 @ 21:09:17 GMT

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

That is what I get for trying to do two things at once, the WHERE clause should have been:

WHERE CHAR(B.DATA_SOURCE_CD) < 11 /* since DATA_SOURCE_CD in the account_event table is CHAR(10) */

Sorry for the hasty posting without reading what I wrote>

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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