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

What are foreign keys in db2?

826


Explain packages.

871


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2669


What's The Percentage Free Space ?

962


What is plan in cobol db2?

797


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

800


What is a db2 cursor?

809


What is the physical storage length of date data type?

997


What is a dbrm in db2?

754


What is db2 optimizer?

1000


What is the difference between oracle and db2?

805


What types of tables are there in the db2 database?

802


Why do we need reorg in db2?

743


What is collection in db2 bind?

776


Which component is responsible for processing sql statements and selecting access paths?

894