Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 17332 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 does select count (*) mean in sql?
what's the difference between a primary key and a unique key? : Sql dba
What is clustered index sql?
When is a declare statement required?
How is a PL/SQL code compiled?
How many unique keys can a table have?
Can we insert data into materialized view?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is self-join and what is the requirement of self-join?
How do I start pl sql?
Why do we go for stored procedures?
Is t sql a programming language?
What is mutating error in pl sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Is delete faster than truncate?
