Join table with a common key

[Black_Hole]

Hello all,

I would like to join two tables with a common key, but when I look for the join table named Service, I don't find it.

Please could you help  me to correct what I do wrong in my join.

Below the structure of my script:

Table_1:

Load

Company,

Country;

SQL SELECT *

FROM SERVERNAME LIBRARY AA;

Table_2:

Load 

Date,

Customer,

Company;

SQL SELECT * FROM SERVERNAME LIBRARY BB;

LEFT JOIN(Table_1)

Service:

LOAD * RESIDENT Table_2;

Thank you in advance for your help.

[anushree1]

join takes the name of the table that it inherits the join from so in your case table 1 will have the result of join with your Service Table

[Black_Hole]

Hello @anushree1,

So, If I want to create in a third table the join between Table_1 and Table_2. 

Please could you advise how I can do that.

Thank you in advance for your help.

[Black_Hole]

Hello all,

I review my first script to join two tables. I take for support the topic from here.

But,  in my table my join is not considered.

Please could you help me to resolve my issue.

JOIN_TABLE:
NOCONCATENATE
LOAD *
RESIDENT CTB;
INNER JOIN (JOIN_TABLE)LOAD * RESIDENT CUST;

IN_CTB:
NOCONCATENATE
LOAD *
RESIDENT JOIN_TABLE;
DROP TABLE JOIN_TABLE;

JOIN_TABLE:
NOCONCATENATE
LOAD *
RESIDENT CTB;
OUTER JOIN (JOIN_TABLE)LOAD * RESIDENT CUST;

OUT_CTB:
NOCONCATENATE
LOAD *
RESIDENT JOIN_TABLE;
DROP TABLE JOIN_TABLE;

Thank you in advance for your help.