Inner Join return only matching rows whereas Outer Join returns matching

What is an inner join, and an outer join ?

Question Posted / s

1 Answers
13041 Views
CTA, I also Faced
E-Mail Answers

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

How do I import data from excel to db2?

1130

How to create backup table in db2?

1150

What is db2 optimizer?

1316

What parameters are used to control the free space in DB2?

1096

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

1084

How to find the maximum value in a column in the db2 database?

1132

Why do we need reorg in db2?

1047

What is the physical storage length of time data type?

1181

define clustering index.

1072

What is role in db2?

1165

How many databases can be created inside an instance in db2 ?

1087

List out the buffer pools in db2

1131

How do I copy a table in db2?

1059

What are the contents of dclgen?

1165

Explain the benefits you can get from mainframe connect?

1018