Script Load SQL Joining

[#1]

How can I join two Oracle tables on Script load

[Peter_Cammaert]

Identical post to the one here: Script Load SQL Joining

Please do not post your questions twice in different forums. Thank you.

[#3]

Hi,

Load 2 tables from oracle and write join (it depends what kind of join u wanna write , u can use left join , Right join, inner join) .....

Ex:

emp:

sql

select * form table1;

left join(emp)

sql

select * from table 2 ;

[its_anandrjs · Accepted solution]

Hi,

Write this way

Rep_Details:
LOAD
`Rep_Id`;
SQL SELECT *
FROM Data;

Join

Rep_Category:
LOAD `Rep_Id`,
`Rep_Name`,
`Category_Desc`;
SQL SELECT *
FROM `Rep_Category`;

Please open single thread for the same question

Script Load SQL Joining

Regards

Anand

[#5]

Thanks its working.

Regards,

Naveed

[#6]

Hi Naveed ,

Please close the thread .......