1 Reply Latest reply: Jun 20, 2013 3:36 AM by Abhijit Bansode RSS

    Dubble left keep

      Dear Community,

       

      I'm got the following situation.

       

      Table_Projects: contains al the project lines in the database.

      Table_Machines: contains the Parts

      Table_People contains the people people.

       

      Table Projects is really big, To visualize what parts en people are working on a project I would like to Left join them both.

       

       

      Example:

      Table_Machines:

      LOAD

      Field 1

      Field 2

      Field 3

      Etc.

      FROM

      DATA\QVD\Table_Parts.QVD

       

      Table_People:

      LOAD

      Field 1

      Field 2

      Field 3

      Etc.

      FROM

      DATA\QVD\Table_People.QVD

       

       

      Table_project:

      Left Keep Table_Machines

      Left Keep Table_People

      LOAD

      Field 1

      Field 2

      Field 3

      Etc.

      FROM

      DATA\QVD\Table_project.QVD

       

       

      What is the most effective way to do this?

       

       

      Regards,

       

      Marco