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

Answers were Sorted based on User's Feedback



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

Answer / kilari hemadri

Joins is used to relate two tables and display the result..
types of joins are

inner join
left join
right join
full join
cross join

inner join : It is used to display the common values in
both the tables based on the condition given.

left join : Left join displays all the contents of left
table and dislays the right table contents that are present
in left table.

right join : it is contraversy to left join

full join : it is combination of both left and right joins.

cross join: it takes one row of left table and matches with
all the rows in the right table.

Is This Answer Correct ?    16 Yes 4 No

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

Answer / jiya jain

The nature of relational database design shows that we will
have related data that is stored in different tables. To
retrieve data from two or more tables we use JOINS.

The JOIN clause tells the database how the data in the two
tables is related so that it can return a correct
representation of the related data.

There are different types of join.

Types of Join are :
1.Self Join
2.Inner Join
3.Outer Join
3.1. Right Outer Join
3.2. Left Outer Join
3.3 Full Outer Join
4.Cross join College Table

For more info go through

http://www.totaldotnet.com/Article/ShowArticle61_SqlServerJo
ins.aspx

Is This Answer Correct ?    4 Yes 0 No

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

Answer / mahesh

joins are used to relate two tables and display the result..

Types of join

1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join

Is This Answer Correct ?    3 Yes 1 No

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

Answer / udaykumar

Join - joining of two tables to itself.
types of joins.....
simple/equi/inner
self
outer
cartesian.

Is This Answer Correct ?    0 Yes 0 No

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

Answer / 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

More SQL PLSQL Interview Questions

write the Sql query for creating database backup?

7 Answers   TCS,


In a distributed database system, can we execute two queries simultaneously?

0 Answers  


What is view explain with example?

0 Answers  


Why do we use cursors?

0 Answers  


Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  






What is sorting in sql?

0 Answers  


How many sql commands are there?

0 Answers  


what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,


What are the different sql languages?

0 Answers  


What is the maximum number of columns in sql table?

0 Answers  


With out using count() function. How to the find total number of rows in a table?

6 Answers  


I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,


Categories