Explain an outer join?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible using max on a char column?

596


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1793


Are views updateable?

635


What is table space in db2?

571


Explain the contention situations caused by locks?

581






What is host variable?

585


What is ibm db2 client?

512


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

735


Mention the definition of cobol in varchar field.

681


What is load utility in db2?

654


Is db2 relational database?

567


What is a db2 cursor?

616


What are the two types of logging in the db2 database? Explain them.

568


How connect db2 database to datastage?

754


What is netezza database?

561