Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2004 @ 15:31:06 GMT

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

The statement can be re-written as :

     Select
     a.account_number,
     a.statement_date,
     b.associate_number
     coalesce(c.source,28)
     FROM    lv_charge_off a INNER JOIN lv_snapshot_all b
     ON      a.account_number = b.account_number
     AND     CAST(a.statement_date (FORMAT 'YYYYMM') AS CHAR(6)) = '200408'
     LEFT OUTER JOIN lv_mcacct_sol_xref c
     ON      a.account_number = c.account_number
     ;

Ajay Reddy

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