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

How can you classify the locks in db2?

643

How to view db2 table structure?

603

What is meant by explain?

668

What is cobol db2?

574

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

641

What is db2? Explain.

611

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

670

What is difference between isnull and coalesce?

626

How to find schema of a table in db2?

578

How do you select a row using indexes in db2?

658

What is the max length of sqlca?

778

Explain packages.

670

What is table space in db2?

593

What is nvl in db2?

637

How can you find out the # of rows updated after an update statement?

652