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
- 6842 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 kind of database is db2?
Explain the benefits you can get from mainframe connect?
What are the contents of a dclmgen?
What is schema in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is a collection in db2?
What is dpf in db2?
What is clone table?
How to create db2 table in mainframe?
What is a dbrm in db2?
What is host variable in db2 cobol?
what is the responsibility of the construction superintendent
What is db2?
How to execute stored procedure in db2 command editor?
What is buffer pool and list some of them?
