Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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.