Archives of the TeradataForum

Message Posted: Thu, 21 May 2009 @ 22:01:51 GMT

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

Hi,

Check on the datatypes of the corresponding columns.

If any column is returning a NULL value from the First SELECT clause, cast that to the datatype of the same column from the SECOND Select clause.

E.g,

     Sel
     case_id,
     cast('' as char(2)),
     row_added_dt
     from support.case
     Union
     sel
     case_id,
     case_type,  -- This is of datatype CHAR(2)
     row_added_dt
     from support.issue;

Regards,

Madhavi

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