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

2 Answers
12570 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I delete a column in db2?

1109

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1093

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4312

Define buffer pool.

1054

What are catalog tables in db2?

1049

How would you find out the total number of rows in a db2 table?

1051

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

1104

What is dbrm?

1105

What is db2 stogroup?

1160

what is the role of the cursor in db2?

1068

What is blu acceleration in db2?

1069

What is page size in db2?

974

What happens in bind step in a db2 program?

971

What is the maximum length of sqlca?

1529

What is the purpose of using commit?

1098