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

    Question about Left Join

    Christian Schmitz



      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!