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
- 6749 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 view db2?
What is collection in db2 bind?
What is the information associated with sysibm.syslinks table?
What is a storage group (stogroup)?
Is db2 relational database?
What is node in db2?
List out the buffer pools in db2
Explain dclgen.
What is db2 catalog database?
Define sqlca.
What is the difference between bind and rebind in db2?
What are db2 objects?
What are the bind parameters ibm db2?
What is the max length of sqlca?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
