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
not working
Again you missed LOAD keyword before Agent_ID
Thank YOU VERY MUCH for your HELP and TIME!
Now it is working.