2 Replies Latest reply: Apr 24, 2018 10:59 AM by Sunny Talwar RSS

    Data Load Editor LEFT JOIN

    Wanyun Yang

      Hi guys,

       

      In my data load editor, I have two tables like:

       

      table1:

      LOAD a AS A, b AS B, c AS C;

      SELECT a,b,c FROM ... WHERE...;

      table2:

      LOAD a AS A, b AS B, d AS D;

      SELECT a,b,d FROM ... WHERE...;


      I'm trying to do table1 LEFT JOIN table2. What should the syntax be?


      Thanks for help!