What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 17740 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the current version of postgresql?
How do I remove duplicates in two columns?
how to use regular expression in pattern match conditions? : Sql dba
what is sql server agent? : Sql dba
what is bcp? When does it used? : Sql dba
what is collation? : Sql dba
Is inner join faster than left join?
What is the current version of sql?
What is the best sql course?
Does group by remove duplicates?
Is primary key always clustered index?
how many tables will create when we create table, what are they? : Sql dba
Do we need to rebuild index after truncate?
how to escape special characters in sql statements? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
