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
12929 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 to find the number of rows in a db2 table?

1116

What are bind parameters in db2?

1044

What's The Percentage Free Space ?

1224

What is load replace in db2?

992

Can you tell me how can you find out the # of rows updated after an update statement?

1095

What is a db2 schema?

1223

How do I connect my db2 database to ibm?

1044

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102

Why do we bind in db2?

1207

How to execute stored procedure in db2 command editor?

1047

What are the various data types available in db2?

1089

What's The Error Code For Unique Index Voilation?

1231

What type of database is db2?

965

What is bufferpool in db2?

1049

Which is faster delete or truncate?

1123