joining of data from two different table by coloums inner join outer join

What is JOIN and different types of JOIN.

Question Posted / nidhi sharma

Answer Posted / nidhi sharma

joining of data from two different table by coloums
inner join
outer join
a.left outer join
b.right outer join
c.full outer join

Is This Answer Correct ?

26 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is schema the same as database?

1006

When do you specify the isolation level?

972

What is db2 connect?

1008

What are db2 tables?

1050

What are bind parameters in db2?

981

Define check constraint.

1025

What do you mean by commit and rollback?

974

What do you mean by between and in? Is between inclusive of specified range values?

1038

Is db2 a mainframe database?

943

Why db2 is called db2?

970

Differentiate between cs and rr isolation levels? Where do you specify them?

1023

What is phantom read in db2?

1072

What is the meaning concurrency in the db2 database?

1056

What is dbrm? What it contains? When it will be created?

992

How to find the number of rows in a db2 table?

1063