Interested to Buy Any Domain ? << Click Here >> for more details...
tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
- 3 Answers
- 8863 Views
- Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
What is a delta record? How you will read it?
What is a ds designer?
What is the roundrobin collector?
What steps should be taken to improve Datastage jobs?
How to find value from a column in a dataset?
Whats difference betweeen operational data stage (ods) and data warehouse?
Define meta stage?
What is the difference between orabulk and bcp stages?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How many types of stage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
Teradata 
