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
- 6365 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 |
Can you tell me how can you find out the # of rows updated after an update statement?
What is a db2 table?
How to handle null values in db2
Is it mandatory to use DCLGEN? If not, why would you use it at all?
Can we update view in db2?
On which levels locks can be applied?
What is the meaning of -805 SQL return code?
What is Call attach facility? How does it work?
What is sqlca?
What is the difference between group by and order by?
what is parm utility
What's The Percentage Free Space ?
COBOL 
