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

Answer Posted / subhash

OUTPUT:
1, a, d
2, b, NULL
3, NULL, c

SQL Query:
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 ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the some differences between 7.x and 8.x version of datastage?

1032


how do u catch bad rows from OCI stage? And what CLI stands for?

2581


What is quality stage?

788


what is the use of materialized view?

1237


What all the types of jobs you developed?

916


What are the important features of datastage?

855


How do you reject records in a transformer?

887


what is 'reconsideration error' and how can i respond to this error and how to debug this

2394


Where the datastage stored his repository?

823


What are the different layers in the information server architecture?

889


Define Job control?

866


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2020


How rejected rows are managed in datastage?

1223


what is repositery?

1576


How many types of views are there in a datastage director?

1089