Hi,
I would like to know how to configure oraoci9 stage in server 7.5 for a outer join between two tables.
Table A
---------
last name
first name
ssn
Table B
----------
ssn
suffix
middle initial
I would like to join on ssn.
Thanx in advance.
outer join in oraoci9 stage
Moderators: chulett, rschirm, roy
You dont need to configure anything. Just deal with the sql.
- -Load the meta data of both the tables
-In the derivations, prefix it with the table alias name that you are going to use. Say A for Table A and B for Table B
-When you go to sql tab, the generated sql will show-In the others section you will putCode: Select all
select A.last_name, A.first_name, A.ssn, B.suffix, B.middile_initial from Table_A A
Code: Select all
left outer join Table_B B ON A.ssn = B.ssn
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: outer join in oraoci9 stage
You dont need to configure anything in the OCI stage to do an outer join.sdfasih wrote:Hi,
I would like to know how to configure oraoci9 stage in server 7.5 for a outer join between two tables.
Table A
---------
last name
first name
ssn
Table B
----------
ssn
suffix
middle initial
I would like to join on ssn.
Thanx in advance.
All you need to write a query to do it.
check this linkto know about the various joins in Oracle.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.