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
- 6681 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 |
How to get Top 10 Salaries from a Table
Where would you find information about the type of database authority held by the user?
How do you eliminate duplicate values in db2?
How to know the primary key of a table without defining the primary key in the table?
what is REORG? what is the use?
What are column-name qualifiers used?
What do you mean by cursor?
What happens to the PLAN if index used by it is dropped?
How many databases can be created inside an instance in db2 ?
what types of copies can be made with the COPY Utility ?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
how do u update the faltfile into db2 table ?
COBOL 
