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
- 6315 Views
- Syntel, I also Faced
- E-Mail Answers
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
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is explain in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to find the number of rows in db2 tables?
What is the physical storage length of timestamp data type?
What is the default page size of buffer pools?
What is syscat in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is plan in cobol db2?
define clustering index.
What is a storage group (stogroup)?
What is universal database?
What is the purpose of rollback and commit?
What is bufferpool in db2?
What is table space in db2?
