3 Replies Latest reply: Oct 20, 2014 5:34 AM by Alessandro Saccone RSS

    Concatenante and joins

    Laura Sébille

      Hello everyone,

       

      I have 6 tables : A1, A2, A3, B1, B2, B3.

       

      I would like to have one big table like this :

       

      A1 concatenate A2 concatenate A3

       

      LEFT JOIN

       

      B1 concatenante B2 concatenante B3

       

       

      What is the more efficient way to do it ?

       

      So far, I have done:

      A:

      LOAD * from A1;

      concatenate

      LOAD * from A2;

      concatenate

      LOAD * from A3;

       

      STORE A into A.qvd;

       

       

      B:

      LOAD * from B1;

      concatenate

      LOAD * from B2;

      concatenate

      LOAD * from B3;

       

      STORE B into B.qvd;

       

      And then

       

      LOAD * from A.qvd(qvd);

      LEFT JOIN

      LOAD * from B.qvd(qvd);

       

       

      That is the only syntax I have found to do it. But I realize I export data in qvd and right after import them so there is probably a more efficient way to do it.

       

      Do you have any idea ?

       

      Thanks for your help