Explain an outer join?



Explain an outer join?..

Answer / vamsikrishnamraju

An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is commit in db2?

0 Answers  


What is buffer pool in the db2 database?

0 Answers  


What is RUNSTATS?

3 Answers  


Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  


In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,


how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,


What is page size in db2?

0 Answers  


What is a Cartesian product?

2 Answers  


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


How to find the maximum value in a column in the db2 database?

0 Answers  


How to create backup table in db2?

0 Answers  


What are the full forms of spufi and dclgen and why are they used?

0 Answers  


Categories