6 Replies Latest reply: Jan 9, 2012 3:55 PM by silviu andries RSS

    Loading table with a field content from another loaded table-help please

    silviu andries

      Hello!

       

      I was searching for a solution in my problem and I could't find anything...

       

      I have 2 tables:

       

      tab1:

       

      load

      A,B,C

      1,100,x

      2,101,x1

      3,102,x2

      from table1.qvd;

       

      tab2:

       

      load
      A,D,F

      1,200,y1

      2,201,y2

      3,202,y3

      4,203,y4

      5,204,y5

      6,205,y6

      from table2.qvd;

       

      Ok. So, after I load the first table, I would like the second table to be loaded only with the values for A field that are in tab1.

      Something like:

       

      load A where A=tab1(A) , D, F

      ........

       

      I was looking for this solution because I have to load a very large amount of data, and I need this condition, that might be preaty simple...

       

      Thank you a lot!

      Silv