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.
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 |
What is a db2 table?
What is host variable in db2 cobol?
Is db2 free?
What is a DB2 bind?
when does the SQL statement gets executed when you use cursor in the application programming ?
what is the sqlcode -501
When would you prefer to use VARCHAR?
What are the abend codes occour in ur latest PROJECT in DB2
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
How do I add a column to a table in db2?
How will fetch last 5 rows from table in db2
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.