What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 16122 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 importance of sqlcode and sqlerrm?
Is sql a case sensitive language?
How do I run a pl sql procedure in sql developer?
how to calculate expressions with sql statements? : Sql dba
Is sql a scripting language?
Does a user_objects view have an entry for a trigger?
Is sqlite good enough for production?
What is a field in a database?
What is varray in pl sql?
What are the 3 modes of parameter?
Does sql backup shrink transaction log?
is it possible to pass an object or table to a procedure as an argument?
Are sql connections encrypted?
What can you do with pl sql?
Does postgresql run on the cloud?
