Archives of the TeradataForum

Message Posted: Tue, 28 Mar 2006 @ 13:28:29 GMT

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

WHY DON' T YOU TRY THIS AND LET ME KNOW IF WORKS:

FIRST STEP:

     REPLACE VIEW VF_2
               AS
               SELECT * FROM FACT_2;

     SECOND STEP:

     SELECT  VF.Col_C,

             VF.Col_F,
             VF.Col_A,
             TA.Col_C
     FROM VF  INNER JOIN TA
     ON TA.Col_A = VF.Col_A
     INNER JOIN TB
     ON TB.Col_A = VF.Col_B
     WHERE TA.Col_B = 
     AND   TB.Col_B = 

     UNION ALL

     SELECT  VF.Col_C,

             VF.Col_F,
             VF.Col_A,
             TA.Col_C
     FROM VF_2 VF  INNER JOIN TA
     ON TA.Col_A = VF.Col_A
     INNER JOIN TB
     ON TB.Col_A = VF.Col_B
     WHERE TA.Col_B = 
     AND   TB.Col_B = 

     ;

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