Archives of the TeradataForum

Message Posted: Mon, 05 Jan 2004 @ 18:07:52 GMT

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

Hi,

I have a query where im doing a self join of the particular table 8 times. What is the limit for doing a self join or is there any alternative way to do .

Select  "SWB_SALES_ORG_SUPPORT_D_V"."SALES_ORG_SUPPORT_IDENTIFIER" "SALES_ORG_SUPPORT_IDENTIFIER"
               ,"GEO_SALES_ORG_STRUC_D_V"."STRUC_TITLE_1" "STRUC_TITLE_1"
               , "GEO_SALES_ORG_STRUC2_D_V"."STRUC_TITLE_2" "STRUC_TITLE_2"
               , "GEO_SALES_ORG_STRUC3_D_V"."STRUC_TITLE_3" "STRUC_TITLE_3"
               , "GEO_SALES_ORG_STRUC4_D_V"."STRUC_TITLE_4" "STRUC_TITLE_4"
               , "GEO_SALES_ORG_STRUC5_D_V"."STRUC_TITLE_5" "STRUC_TITLE_5"
               , "GEO_SALES_ORG_STRUC6_D_V"."STRUC_TITLE_6" "STRUC_TITLE_6"
               , "GEO_SALES_ORG_STRUC7_D_V"."STRUC_TITLE_7" "STRUC_TITLE_7"
--              , "GEO_SALES_ORG_STRUC8_D_V"."STRUC_TITLE_8" "STRUC_TITLE_8"
From    "DPADMIN"."SWB_SALES_ORG_SUPPORT_D_V" "SWB_SALES_ORG_SUPPORT_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC2_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC3_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC4_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC5_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC6_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC7_D_V"
              , "DPADMIN"."geo_sales_org_struc_d_v" "GEO_SALES_ORG_STRUC8_D_V"
Where   "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC_D_V"."STRUC_LEVEL_ID_1"
        And     "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC2_D_V"."STRUC_LEVEL_ID_2"
        And     "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC3_D_V"."STRUC_LEVEL_ID_3"
        And     "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC4_D_V"."STRUC_LEVEL_ID_4"
        And     "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC5_D_V"."STRUC_LEVEL_ID_5"
        And     "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC6_D_V"."STRUC_LEVEL_ID_6"
        And     "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC7_D_V"."STRUC_LEVEL_ID_7"
      And       "SWB_SALES_ORG_SUPPORT_D_V"."USER_CLASS" = "GEO_SALES_ORG_STRUC8_D_V"."STRUC_LEVEL_ID_8"

Thanks

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