AnsweredAssumed Answered

Help Multiway Merge Join

Question asked by Aslee Guirola on Mar 2, 2018
Latest reply on Mar 13, 2018 by Jill Ross

Greetings Community.

I hope you help me with a union I want to make with 16 tables that relate different fields.

Example:

 

INGRP1.SA_ID  =  SA.SA_ID And

SA.ACCT_ID =  ACCT.ACCT_ID  And

  ACCT.ACCT_ID =  ACCT_PER.ACCT_ID  And

     INGRP1.FT_ID  = TRANS_FINANC.TF_ID  And  

      INGRP1.FT_TYPE_FLG  = TIPO_TF.TIPO_TF_CODIGO  And  

       INGRP1.PARENT_ID   = PAGOS.PAGO_ID  And  

        SA.START_OPT_CD  = OP_INIC.OP_INIC_CD  And  

         SA.CIS_DIVISION  = OP_INIC.OP_INIC_DIVISION_CIS And  

          SA.SA_TYPE_CD  = OP_INIC.OP_INIC_TIPO_AS  And  

           INGRP1.BILL_ID  = FACTURA.FACTURA_ID  And  

            SA.ACCT_ID  = CUENTA.CUE_ID  And  

             INGRP1.DST_ID  = COD_DIST.COD_DIST_ID  And  

              INGRP1.TIPO_AJUSTE  = AJUSTE_TIPO.ATIPO_ID  And  

INGRP1.SA_ID  =  ACUERDO_SERV.ASF_ID  And

                ACCT_PER.PER_ID  = PERSONA.PER_ID

Outcomes