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
Can cursors be part of a trigger body?
What is sequence in sql?
Is a secondary key the same as a foreign key?
Is it possible to pass parameters to triggers?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What are the qualities of 2nf?
How do I view stored procedures?
tell us something about heap tables. : Sql dba
How do I install microsoft sql?
What is right join in sql?
What do you understand by pl/sql cursors?
What are all different types of collation sensitivity?
What is the use of double ampersand (&&) in sql queries? Give an example
In what condition is it good to disable a trigger?
what are the join types in tsql? : Transact sql