Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 09:25:53 GMT

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

Hi all,

I have a column in my select statement that I will like to populate with values from either of two tables in a multiple-join SQL. For example, if data in a certain column of join condition(1), populate col1 with it else use data from join condition(2) to populate col1. I have been thinking of a good efficient way to do this and I could use the help of our SQL gurus on this column.

Here's the SQL I'm trying to use as a example,

SELECT col1, col2,... coln

From BA.DLY_LN_ACCNT                             LA    (1)
Join BACURRENT.Ln_Dt_Rng                         LDR
On   LA.process_dt     = LDR.end_extract

Join BA.Dly_AccNT                                A     (2)
On   A.ba_accnt_nbr    =  LA.ba_accnt_nbr
And  A.process_dt      =  LA.process_dt

Join BA.Dly_Accnt_Risk                           AR    (3)
On   A.ba_accnt_nbr    =  AR.ba_accnt_nbr
And  A.process_dt      =  AR.process_dt

Join ba.Dly_Ppant                                PART  (4)
On   PART.ba_accnt_nbr        = A.ba_accnt_nbr
And  PART.process_dt          = A.process_dt
;

Again, your contributions is always appreciated.

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