3 Replies Latest reply: Jul 19, 2017 8:22 AM by P M RSS

    Question about Left Join

    Christian Schmitz

      Hi,

       

      I have a general question, to understand the left join.

       

      If my first table1 is filled with following fields: ID, A,B,C

       

      and the second table2 has two fields: ID, Z

       

      and I make a:  left join (table1) Load ID,Z Resident table2;


      Will this work , to the first table the field Z will be properly joined ? Or do I need in my second table also the fields A,B,C?

       

      Thanks for your help!