What are the different types of JOINs in SQL Server?

Answers were Sorted based on User's Feedback



What are the different types of JOINs in SQL Server?..

Answer / guest

INNER JOIN
b. LEFT JOIN or LEFT OUTER JOIN
c. RIGHT JOIN or RIGHT OUTER JOIN
d. FULL JOIN or FULL OUTER JOIN
e. CROSS JOIN

Is This Answer Correct ?    13 Yes 0 No

What are the different types of JOINs in SQL Server?..

Answer / srinivasula reddy

Inner Join
Self Join
Left Outer Join
Right Outer Join
Full Outer Join

Is This Answer Correct ?    2 Yes 0 No

What are the different types of JOINs in SQL Server?..

Answer / g.supriya

full join or full outer join

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Dot Net WindowsForms Interview Questions

For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this?

1 Answers   Microsoft,


what are the diffrences between windows application and windows service?

2 Answers  


What is the full form of gac?

0 Answers  


What are window based applications?

0 Answers  


We are facing problem with the compatibilty of IE 7 and IE 6.We are calling a showModal window that is working fine in IE6 but with IE7 it opens a new Window and Data is not getting poputaled.In some pages it Gives an error "The webpage you are viewing is trying to Close the window.Do you want to close this window".

1 Answers   Wipro,






what are the differences between image and picture controls?

1 Answers  


Is form action required?

0 Answers  


What is a windows form application?

0 Answers  


where we are using NEW keyword other than create instance Pls Help me? Gopal

6 Answers  


What is the difference between the add() and insert() methods of a listbox control?

0 Answers  


What are the advantages of form?

0 Answers  


____ property is used to lock a textbox to enter data.

5 Answers  


Categories