select * from tab1 full outer join tab2 on tab1.key_column=tab2.key

tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?

Question Posted / karthi

3 Answers
8730 Views
Infotech, I also Faced
E-Mail Answers

Answer Posted / karthi

select * from tab1 full outer join tab2 on
tab1.key_column=tab2.key_column;

or

select * from tab1,tab2 where tab1.key_column(+)=tab2.key_column
union
select * from tab1,tab2 where
tab1.key_column=tab2.key_column(+);

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

options available in sequence job to run,validate?

1260

What are the partitioning techniques available in link partitioner?

2228

How many types of hash files are there?

1121

How you Implemented SCD Type 1 & Type 2 in your project?

4075

What are the types of containers?

1142

What is difference between join, merge and lookup stage?

1041

What are routines in datastage? Enlist various types of routines.

1047

How to RD using transformer?

1367

What is the different type of jobs in datastage?

902

Can you define merge?

1065

Have you have ever worked in unix environment and why it is useful in datastage?

1084

What is the purpose of pivot stage?

1100

Define meta stage?

1144

What is active and passive stage?

1360

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2407