Diff types of join 1. Inner 2.Left Outer 3.Right Outer 4.Cartesian

What are the different types of joins and what does each do?

Question Posted / sachin patil

Answer Posted / sachin patil

Diff types of join

1. Inner
2.Left Outer
3.Right Outer
4.Cartesian
5.Self Join

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is logshipping and its purpose?

990

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

What is the difference between upgrade and migration in sql server?

1097

What are system databases into sql server (2005/2008) : sql server database administration

1019

What is ddl and dml commands?

907

How to use wildcard characters in like operations in ms sql server?

1138

What are database states in ms sql server?

1183

What happens if null values are involved in comparison operations?

977

What is sql server programming?

1046

Explain the microsoft sql server delete command? : SQL Server Architecture

1091

What is a transaction and why is it important?

1092

What is implicit cursors?

1088

What are system databases in ms sql server?

1062

Is it possible in sql table to have more than one foreign key?

1036

What is 'write-ahead log' in sql server 2000 ?

1062