1 Reply Latest reply: Dec 30, 2014 9:14 AM by Fernando Keuroglian RSS

    Scripting

      Hi

      i am having some trouble doing the following: I have imported some qvd files that have automatically linked in outer join. What i need to do now is to create a table, that i will need to store as qvd, that bings togheter fields from the differen tables.

       

      How do i do this? I don't understand which is my 'from statement'.

       

      tx

        • Re: Scripting
          Fernando Keuroglian

          Hi Niccolo, you wil have to use Resident and join or concatenate the tables bring from qvd

           

          example

           

          TABLE1:

          load A,B,C from qvd1

           

          TABLE2:

          load A,X,Z from qvd2

           

          newtable

          load A,B,C

          resident TABLE1;

           

          left join

           

          load A,X,Z

          resident TABLE2;

           

          good luck

          Fernando