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.
Answer Posted / 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 |
Post New Answer View All Answers
What is a db2 table?
What is table space in db2?
What is catalog database in db2?
What are iseries servers?
Are views updateable?
What are db2 tables?
what is db2 restart?
can we view the access paths created by dbrm ? how ? thx
How to get the ddl of a table in db2?
What is db2 look?
What is node in db2?
What is access path in db2?
Is it possible using max on a char column?
What are union and union all?
what are bind concepts in db2 cobol?