What is an inner join, and an outer join ?
Answer / s
Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.
| Is This Answer Correct ? | 27 Yes | 2 No |
What is difference between isnull and coalesce?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
Is db2 free?
how do u update the faltfile into db2 table ?
What is bind package and plan in db2?
What is an alias and how does it differ from a synonym?
how to identify the pseudo conversation by seeing the program
What are the bind parameters ibm db2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How do I change the column size in db2?
what is the input to PLAN? what is the input to DBRM?
What is the SQL Communications Area and what are some of its key fields?