5 Replies Latest reply: Aug 1, 2017 3:09 AM by Onno van Knotsenburg RSS

    Is possible to delete the intersection data from a left join?

    Ivan Cortes Morales

      hello!

       

      I have this situation and I need your help. Im doing a left join with two tables, and this join  create a new table with the first table data and its data intersection like this example with sql statement.

      IMG_0822.JPG

      I need to take the data of A with no  intersection data with B like this example:

      IMG_0822.JPG

      Im trying to do this using the LOAD statement but it doesnt work.

       

      [My Join]

      LOAD 

      campo1, //key

      campo2, //key

      campo3

      FROM [tabla A];


       

      LEFT JOIN ([My Join])

      LOAD

      campo1, //key

      campo2, //key

      campo4,

      campo5

      FROM [tabla B];

      where IsNull(campo1) and isNull(campo2);