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
What are the some differences between 7.x and 8.x version of datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is quality stage?
what is the use of materialized view?
What all the types of jobs you developed?
What are the important features of datastage?
How do you reject records in a transformer?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Where the datastage stored his repository?
What are the different layers in the information server architecture?
Define Job control?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How rejected rows are managed in datastage?
what is repositery?
How many types of views are there in a datastage director?