Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking syntax like LEFT JOIN for SQL queries...
I have to SQL Tables.
SQL_Table_1:
SELECT
ID,
A,
B,
C
FROM XXXXX;
SQL_Table_2:
SELECT
ID,
E
FROM YYYYY;
I need to get LOAD query from two RESIDENT tables: SQL_Table_1 and SQL_Table_2, in order to get: ID, A, B, C, E
Something like:
LOAD
A,B,C,ID
RESIDENT SQL_Table_1
LEFT JOIN
LOAD
E,ID
RESIDENT SQL_Table_2
I can easily connect tables in SQL queries, but how can I do it in LOAD queries
Again you missed LOAD keyword before Agent_ID
ABC:
LOAD
A,B,C,ID
RESIDENT SQL_Table_1
LEFT JOIN (ABC)
XYZ:
LOAD
E,ID
RESIDENT SQL_Table_2
or
ABC:
LOAD
A,B,C,ID
RESIDENT SQL_Table_1
LEFT Keep (ABC)
XYZ:
LOAD
E,ID
RESIDENT SQL_Table_2
I have syntax error on LEFT JOIN or LEFT KEEP sentence after the first part
What error your facing?
after Agent_ID please close statement with ;(semicolon)
I tried
Try this
TEST:
Left Join (.............)
LOAD
Agent_ID,
......
Resident .......
Much closer, but still something missing ..
TEST:
Left Join (Loda_budget_for_two_types)
LOAD // remove from here....
Agent_ID,
......
Resident .......