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
- 6662 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 |
Why db2 is called db2?
What is dbrm library?
What language is db2 written in?
Can we update view in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What kind of database is db2?
How do I create a view in db2?
Compare a subselect to a join?
can any one expalin check point with an example?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is cursor?
What is a bind card?
COBOL 
