
Creator III
2018-04-24
10:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data Load Editor LEFT JOIN
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!
9,375 Views
1 Solution
Accepted Solutions

MVP
2018-04-24
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...;
2 Replies


Partner - Champion
2018-04-24
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...;
9,305 Views

MVP
2018-04-24
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...;
