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 / 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 |
How do I copy a table in db2?
What is a Database Request Module(DBRM)?
what is the difference between normal select query and currosor
What does CURRENTDATA option in bind indicate
What information is used as input to the bind process?
Can we insert update delete in view?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
how to resolve -811
How is a typical db2 batch pgm executed?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Explain how can you do the explain of a dynamic sql statement?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?