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 SMP/E? and what are the major steps of it? thanks...
How would you print the output of an SQL statement from SPUFI?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What is referential integrity?
max number of columns in a db2 table?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What happens to a cursor after a commit?
What is the meaning concurrency in the db2 database?
What is Declaration Generator(DCLGEN)?
What is the difference between dbm cfg and db cfg file in db2 ?
What is load utility in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?