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

[prma7799]

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

[sculptorlv]

I have syntax error on LEFT JOIN or LEFT KEEP sentence after the first part

[prma7799]

What error your facing?

[sculptorlv]

[prma7799]

after Agent_ID please close statement with ;(semicolon)

[sculptorlv]

I tried

[prma7799]

Try this

TEST:

Left Join (.............)

LOAD

Agent_ID,

......

Resident .......

[sculptorlv]

Much closer, but still something missing ..

[prma7799]

TEST:

Left Join (Loda_budget_for_two_types)

LOAD  // remove from here....

Agent_ID,

......

Resident .......