explain different types of jions with examples briefly?
- 3 Answers
- 9718 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / ramesh
Basically Joins are used to get result from two or more
tables and there are two types of joins
inner join and outer join
Inner join : a join of two or more tables which omits the
blank rows while checking
Outer join is subcatogorised in to left outer join and right
outer join. Which includes blank rows in specifed side if
condition satisfies.
Simple outer join is combination of left and right outerjoins.
Apart from these there are
Natural join : cartisian product
Equi join : which includes = operator in condition
NonEqui join : All conditional joins which doesn't uses = in
there conditions.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to provide values to user defined function parameters?
What are the differences between clustered and non-clustered index?
explain different types of constraints? : Sql server database administration
What is SQL Azure Fabric?
What are the dis_advantages of stored procedures, triggers, indexes?
How to create an identity column?
How to enter unicode character string literals in ms sql server?
Explain indexing and what are the advantages of it?
Is the primary key column of a table an index in ms sql server?
What are the options which must be set to allow the usage of optimistic models?
Does full backup break log chain?
Is foreign key a primary key?
How to search for a string in all stored procedure in sql server?
Explain the purpose of indexes?
What is a transact-sql statement batch in ms sql server?
