Archives of the TeradataForum
Message Posted: Wed, 29 Sep 2004 @ 14:51:43 GMT
I am fairly new to Teradata database .
I have to join 3 tables . Inner join of a and b and the result should be left outer joined with C . It is showing some syntax error in the last 2 statements :
1) In cast statement
2) Expecting something between b and '.'
Select a.account_number, a.statement_date, b.associate_number coalesce(c.source,28) from lv_charge_off a, lv_snapshot_all b left outer join lv_mcacct_sol_xref c on a.account_number = c.account_number where a.account_number = b.account_number and CAST(CAST(a.statement_date AS DATE FORMAT 'YYYYMM') AS CHAR (6)) = CAST (200408 AS CHAR(6)) ;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|