Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2005 @ 16:07:32 GMT


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

Subj:		Applying LEFT OUTER JOIN in the WHERE condition

From:		Anomy Anom

<-- Anonymously Posted: Thursday, January 13, 2005 11:04 -->

Hi,

I have a query

     Select "T1"."ACCOUNT_KEY" "C0"
          , "T2"."COMPANY_KEY" "C1"
          , sum("GL_JOURNAL_DETAILS_F_V"."LOCAL_CURRENCY_AMOUNT") "C2"

          From ("EDW_REP_SOURCE"."GL_JOURNAL_DETAILS_F_V" "GL_JOURNAL_DETAILS_F_V"
                     LEFT OUTER JOIN "EDW_REP_SOURCE"."ACT_ACCOUNT_D_V" "T1"
              On "GL_JOURNAL_DETAILS_F_V"."AFF_ACCOUNT" = "T1"."ACCOUNT_KEY")
                     LEFT OUTER JOIN "EDW_REP_SOURCE"."ACT_COMPANY_D_V" "T2"
              On "GL_JOURNAL_DETAILS_F_V"."AFF_COMPANY" = "T2"."COMPANY_KEY"

          Where "T2"."COMPANY_KEY" In ('500110', '510110')
           And "GL_JOURNAL_DETAILS_F_V"."PERIOD_ID" In (200401,200402,200403)
           And "GL_JOURNAL_DETAILS_F_V"."AFF_COMPANY"  NOT  In ('310310')

          Group By "T1"."ACCOUNT_KEY", "T2"."COMPANY_KEY";

Is there a way I can apply the LEFT OUTER JOINS in the WHERE condition as we do in Oracle.

Thanks


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