Software job search
.net sql interview questions
  The best place for technical interview questions

 
Home.netSql serverAsp.netC#Vb.netAdo.netAjaxMcpd dumpsWord count tool
You are here >> sql server interview questions  
Question. What are the different types of joins

Inner Join – This is the default join in SQL server. In this join data will be retrieved only if both the tables have a matching record

Left outer join (also known as left join) – in this join all the rows of the first (left) table will be returned. If it is not able to find a match in the second (right) table null values will be displayed. Otherwise values of the right table will be displayed

Right outer join (also known as right join) – in this join all the rows of the second (right) table will be returned. If it is not able to find a match in the first (left) table null values will be displayed. Otherwise values of the left table will be displayed

Cross join – A Cartesian product of both tables will be displayed. If table A has 2 rows and table B has 5 rows the resulting join will have 10 rows (2 x 5)




Previous question Next question
 Rate this answer
     
 35 votes , average 4 out of 5

Back to sql server interview questions
This question has been viewed 13152 times   

Other questions on sql server interview questions




More SQL Server interview questions
SQL Server interview questions

Reader's opinions -

No comments
Loading

 
.net interview questions
Asp.net interview questions
C# interview questions
Vb.net interview questions
Ado.net interview questions
Ajax interview questions
Wcf interview questions
Wpf interview questions
.net threading interview questions
.net remoting and webservices interview questions
.net caching interview questions
.net oops interview questions
Sharepoint interview questions
Jquery interview questions
Silverlight interview questions
Linq interview questions
Wwf interview questions
Java interview questions
Sql server interview questions
Ssis interview questions
Ssrs interview questions
Data warehousing interview questions
Data mining interview questions
Oracle interview questions
Php interview questions
Design patterns interview questions
Uml interview questions
Mcpd dumps
Pmp practice tests

This site is best viewed with Internet Explorer 7.0 or higher, Firefox 2.0 or higher, Chrome at a minimum screen resolution of 1024x768.
A complete solution to interview questions
free matrimonial website      
web hosting plans |  compare vps hosting plans |  Compare dedicated hosting plans |  Compare linux hosting plans |  Compare cloud hosting plans |  Compare windows hosting plans | 
Hosting reviews |  GoDaddy reviews | 
Support Wikipedia