2 Replies Latest reply: Aug 17, 2016 8:03 PM by Marco Wedel RSS

    Concatenate the same table for each row from another table

    yuan du

      Hi everyone,

       

      My question stated in the tittle could also being asked as merge two tables without key. Is there a loop function to complete this?

      I have a tableA with one field "Procedure code". and I have tableB with two fields "Campus" and "Date". I want to repeat the tableB for each row in tableA. The tables like this:

      tableA:             

      Procedure code
      Proc1
      Proc2
      Proc3

      tableB:

       

      CampusDate
      A201501
      B201502
      C201503

      I want the merged table look like this:

       

      Procedure codeCampusDate
      Proc1A201501
      Proc1B201502
      Proc1C201503
      Proc2A201501
      Proc2B201502
      Proc2C201503
      Proc3A201501
      Proc3B201502
      Proc3C201503


      Thank you in advance!