2 Replies Latest reply: Sep 27, 2016 2:54 PM by Peter Cammaert RSS

    Load with where condition from Resident table

    Steeven Rampani

      Hello ,

       

      I one issue with Resident tables and Where conditions  !

      I have 2 tables

       

      TableA:

      Load

      A,

      B,

      C

      From xxx.Qvd(qvd);

       

      TableB:

      Load

      D,

      E,

      F,

      G

      From zzz.Qvd(qvd);


      I want create one third table with this condition:


      TABLEC:

      LOAD

      A*(D/E) as Quantity,

      B as Material,

      G as Unit

      WHERE B=F AND C=G


      Some ideas? Solutions?