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

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


Which catalog tables contain authorization information?

1 Answers  


How do I add a column to a table in db2?

0 Answers  


What's The Percentage Free Space ?

0 Answers   IBM,






What does reorg do in db2?

0 Answers  


What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,


How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  


Name the lockable units in DB2?

0 Answers  


What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


What is meant by concurrency?

1 Answers  


Categories