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
- 17397 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
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How are sql commands classified?
What is an alias command?
How many types of normalization are there?
What is procedure explain with program?
What is the purpose of the primary key?
Is pl sql different from sql?
What is the difference between alter trigger and drop trigger statements?
Can we write dml inside a function in sql server?
what tools available for managing mysql server? : Sql dba
Name three sql operations that perform a sort.
How to combine two stored procedures in sql?
What are the different parts of a package?
What is difference between joins and union?
what are the different type of sql's statements ? : Sql dba
