4 Replies Latest reply: Oct 5, 2017 9:42 AM by giuseppe alleruzzo RSS

    Union and join tables

    giuseppe alleruzzo

      Hello Guys,

       

      I have 3 tables, A, B and C. I need to make in Load Script an union between B and C and then a join with A. how can I do?

       

      I tried in this way (it doesn't work):

       

      Load * from A;

       

      inner join

       

      temp:

      Load * from B;

      Concatenate(temp)

      Load * from C;

       

      Tables B and C have the same columns.

       

      Thank you so much