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

Why select is not preferred in embedded sql programs?

705


Can we insert update delete in view?

569


What is ibm db2 client?

515


What is the physical storage length of date data type?

722


What are iseries servers?

560






What is meant by union and union all?

577


What is the role of data manager in the db2 database?

636


What is a db2 collection?

601


Highlight all the advantages that are attached to a package.

621


What is data manager?

601


What is sqlca’s maximum length?

664


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

739


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

593


What are the prerogatives?

612


What is null indicator in db2?

597