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
- 6767 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 |
Give some example of statistics collected during RUNSTATS?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
How could one combine a set of incremental image copies into a single copy?
how to check the table is empty or not?
What is a synonym? How is it used?
how can we retrieve the 100 records of the file ?
How to update more then one record using update?
Q3. How will you fetch duplicate values from a DB2 table?
How can we retrieve the total number of records in RPG & CLLE?
What is deadlock?
What are the prerogatives?
What is sqlcode -922 ?
COBOL 
