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
- 17589 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
How do I kill a query in postgresql?
Can delete statement be rollbacked?
Is pl sql different from sql?
how to use case expression? : Sql dba
What do you mean by dbms? What are its different types?
What is graph sql?
when MSQL8.0 is in market
what is a composite primary key ? : Sql dba
Why do we use joins?
What are the properties of a transaction?
What is the difference between in and between in sql?
How do you take the union of two tables in sql?
What are the most important ddl statements in sql?
How do I filter in sql profiler?
What are the string functions in sql?
