Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6751 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 |
How does DB2 determine what lock-size to use?
How do you prepare a COBOL + DB2 program from coading till execution ?
Define check constraint.
What are simple, segmented and partitioned table spaces ?
How to find last record before record through SQLRPGLE?
What is alias in db2?
How to update more then one record using update?
What is the role of union all and union
What is -904 sql code? How to resolve it?
What is db2 and what is the use of db2 optimizer?
What is temporal table in db2?
How to compare data between two tables in db2?
COBOL 
