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
- 6343 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 |
What is the difference between nvl and coalesce?
What is QUIESCE?
In terms of DB2 indexing, what is the root page?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
Where can you declare a cursor in a cobol-db2 program?
What is IMAGECOPY ?
What is the purpose of the DSNC transaction ?
What is load utility in db2?
How will fetch last 5 rows from table in db2
can i code union in cobol-db2 pgm ?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is dbrm?
COBOL 
