Data Load Editor LEFT JOIN

[wanyunyang]

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!

[agigliotti]

by the below code:

table1:

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

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

left join

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

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

[sunny_talwar · Accepted solution]

May be this

table1:

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

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

Left Join (table1)

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

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