What is meant by Join? What are the different types of
Joins available? Explain.

Answer Posted / dinesh kumar

Joins -- Getting related data from more than one table.

Type:
Inner JOin --Equi Join -- Non Equi join
Outer JOin --LEft Join -- Right Join -- Full Outer JOin
CRoss Join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you break a loop in pl sql?

517


What is scalar and vector?

523


What is consistency?

702


What is sql query optimization?

538


how many tables will create when we create table, what are they? : Sql dba

535






What's the difference between a primary key and a clustered index?

505


Why is pl sql needed?

503


Can you have more than one trigger on a table?

526


What is a sql schema used for?

539


what tools available for managing mysql server? : Sql dba

524


What is varchar sql?

609


What is informix sql?

532


How do you optimize a stored procedure in sql?

494


What is the execution plan in sql?

551


What is sql table?

518