2 Replies Latest reply: Dec 17, 2012 1:49 AM by sujeet singh RSS

    Linking Tables

      Hi,

       

      I would like to ask for help. I have 3 tables that needs to be linked to each other.

       

      Table 1

      Load

           DATE

           LINEPRICE as LINEAMOUNT,

                 ENTRYID & '-' & DATE &'-'& BRANCHNAME as GNDLINEKEY,

           ITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY

          

      Resident PARENT_TEMP

      where VOIDED <> 1;

       

      Table 2

      LOAD

           COMBOITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY

      Resident GNDITEM_COMBO_TEMP

      where VOIDED <> 1;

       

      Table 3

      LOAD

             ENTRYID & '-' & date(floor(TRIM(DOB))) &'-'& TextBetween(FileBaseName(),'_','_') as GNDLINEKEY

      FROM

      $(DIR1)KR_*_GNDLINE_2012.qvd

      (qvd)

       

      I need to link table 2 and 3 without creating loops.

       

      Thanks in advance,

       

      Janzen