How to combine to LOAD together

[sculptorlv]

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

[sculptorlv]

not working

[prma7799 · Accepted solution]

Again you missed LOAD keyword before Agent_ID

[sculptorlv]

Thank YOU VERY MUCH for your HELP and TIME!

Now it is working.