What is meant by Join? What are the different types of
Joins available? Explain.
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
How to rename a table?
What is a rank in sql?
Why do we use procedures?
What is the use of nvl function?
What does cursor do in sql?
Is microsoft sql free?
Mention what are different methods to trace the pl/sql code?
What is a schema? How is it useful in sql servers?
Explain character-manipulation functions?
What is sqlca in powerbuilder?
tell me about various levels of constraint. : Sql dba
Does truncate require commit?
What is natural join in sql?
How to download oracle sql developer?
What is the use of procedures?