OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2
OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE
SAME THEN WHAT IS THE USE OF OUTER JOINS.
- 1 Answers
- 6297 Views
- Syntel, I also Faced
- E-Mail Answers
Answer / ravi
Simple joins gives only matching/common values from two or
more tables
If you have mentioned only Outer joins then it is same as
simple join gives the matching values from two or more
tables but outer joins are of two types--- right outer join
and left outer join
for right outer join--- it will give non matching rows also
from right table in addition to matching rows
for left outer join-- it will give non matching rows also
from left table in addtion to matching rows
| Is This Answer Correct ? | 13 Yes | 0 No |
What is cobol db2?
can you use symbolic parameters in JOB?
What does the REORG Utility do?
what is Static and dynamic linking
How many sub queries can you combine together ?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Explain the function of data manager.
What is query for your birthday date should be in hours,minute and seconds format?
How to execute stored procedure in db2 command editor?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
How do you Load a table ?? and what is Load replace ?
How to define the data items to receive the fetch items for the SQL?
COBOL 
