What is an inner join, and an outer join ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

855


What is the clustering index in the db2 database?

770


What is the syntax for seeing the columns and data types of a table in the db2 database?

847


How do you select a row using indexes in db2?

870


What is the role of union all and union

887


Which components manage deadlocks in db2?

833


Explain about open switch business continuity software?

859


What is null value in db2?

783


What is the advantage in De-normalizing tables in DB2?

962


What is table space in db2?

804


what is a corelated subquerry?

855


What is dbrm?

883


What is the use of runstats in db2?

827


What is syscat in db2?

791


How do you simulate the explain of an embedded sql statement in spufi/qmf?

866