Archives of the TeradataForum

Message Posted: Thu, 30 Sep 2004 @ 07:57:53 GMT

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

Join syntax for

     Select
     a.account_number,
     a.statement_date,
     b.associate_number
     coalesce(c.source,28)
     from lv_charge_off a
     join lv_snapshot_all b
     on a.account_number = b.account_number
     left outer join lv_mcacct_sol_xref c
     where
     a.account_number = c.account_number
     and
     CAST(CAST(a.statement_date AS DATE FORMAT 'YYYYMM') AS CHAR (6)) = CAST
     (200408 AS CHAR(6)) ;

Thanks & Regards,

Lakshman

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