3 Replies Latest reply: Aug 6, 2009 6:47 PM by clara2009 RSS

    Joining QVDs

    clara2009

      Hi Guys,

      Can I join two (or more QVDs) using SQL type queries.

      Example:

      I have two QVDs which have one common column using which i would like to do a outer join and fetch some columns from both the qvds. Is it possibe? Some thing like the one below!!!

      LOAD

      a.X, b.X, a.Y,a.Z

      from abc.qvd (qvd) a LEFT OUTER JOIN def.qvd (qvd)

      ON a.X=b.X

      Regards,

      Clara