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

What is ibm db2 database?

534


Explain about open switch business continuity software?

563


What is db2 instance?

590


What is role in db2?

620


Define sqlca.

647






What are packages in db2?

596


can we view the access paths created by dbrm ? how ? thx

6247


What is data manager?

607


What are db2 tables?

647


What os does db2 run on?

570


what is a corelated subquerry?

658


What is iseries database?

597


can all users have the privilage to use the sql statement select * (dml)?

639


Is schema the same as database?

629


How to view db2 table structure?

590