What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
Answer Posted / prangya mishra
joins are used for retreiving the information from multiple
tables at a time & presenting it.
we have 5 different types of joins
1.Equi join
2.Non-Equi join
3.Self join
4.Cartesian join
5.outer join
Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
Is sql server free?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is transactional replication?
Tell me about pre-defined functions of sql?
Define inner join in sql server joins?
What to perform pattern match with the like operator?
what's the information that can be stored inside a bit column? : Sql server database administration
How many types of triggers in sql server?
Define outer join?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What will be the maximum number of index per table?
How to use subqueries with the in operators in ms sql server?
Mention a few common trace flags used with sql server?
What is etl - extraction, transformation, and loading?