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
- 6689 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
What is a page in db2?
Explain the contention situations caused by locks?
What is the difference between nvl and coalesce?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is a db2 schema?
What is difference between alias and synonym in db2?
What r the comman abends in db2, jcl and cobol???????
What is null in db2?
Which are the db2 tools to protect integrity of the database?
Is ibm db2 open source?
How to create backup table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is bind in db2?
What is db2 and what is the use of db2 optimizer?
What is the syntax for seeing the columns and data types of a table in the db2 database?
