3 Replies Latest reply: Jun 18, 2012 11:30 AM by Rob Wunderlich RSS

    Concatenating Tables

    brandon breitling

      I have 3 tables with the same field names.  Is there anyway I can concatenate the tables into one table with the same field names?

       

      VendorRAN:

      load

      (APHVCH) as LINK_KEYV1,

      APHVCH,

      Concat(if(APHNAM<>'SIOUX FALLS TAX',if(APHNAM<>'BALTIC TAX',if(APHNAM<>'EARTH CITY TAX',if(APHNAM<>'HURON TAX',if(APHNAM<>'TEXAS TAX - AUSTIN',APHNAM))))),'; ') as C

      FROM

      $(vQVDPath)AppVendorRAN.qvd (qvd);

       

      VendorAER:

      load

      (APHVCH) as LINK_KEYV1,

      APHVCH,

      Concat(if(APHNAM<>'SIOUX FALLS TAX',if(APHNAM<>'BALTIC TAX',if(APHNAM<>'EARTH CITY TAX',if(APHNAM<>'HURON TAX',if(APHNAM<>'TEXAS TAX - AUSTIN',APHNAM))))),'; ') as C

      FROM

      $(vQVDPath)AppVendorAER.qvd (qvd);

       

      VendorCAN:

      load

      (APHVCH) as LINK_KEYV1,

      APHVCH,

      Concat(if(APHNAM<>'SIOUX FALLS TAX',if(APHNAM<>'BALTIC TAX',if(APHNAM<>'EARTH CITY TAX',if(APHNAM<>'HURON TAX',if(APHNAM<>'TEXAS TAX - AUSTIN',APHNAM))))),'; ') as C

      FROM

      $(vQVDPath)AppVendorCAN.qvd (qvd);