What is JOIN and different types of JOIN.

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

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

883


What language is db2 written in?

798


What is reorg?

853


Comment whether the cursor is closed during commit or not.

877


What are union and union all?

737


What are the bind parameters ibm db2?

819


What is buffer pool?

859


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2530


Is it possible using max on a char column?

873


Highlight all the advantages that are attached to a package.

894


Can you use max on a char column?

842


What is the difference between drop table and delete table?

811


How will you return the number of records in table?

716


How can you count the number of rows from a table tab?

848


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

875