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:



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

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


      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!