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 method is used by the Command classes to execute SQL statements that return single values?

1004

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1154

Does a full backup include transaction log?

907

your distribution database is full what will u do

2126

Do you have any idea about the tcl commands?

910

How to retrieve error messages using odbc_errormsg()?

990

What is the purpose of update statistics and scope_identity() function?

1049

What is mean by dml?

945

What is a non equi join?

913

Can sql servers link to other servers like oracle?

789

what are the reporting service components in SSRS?

151

Explain the concept of recursive stored procedure.

879

How to change parameter value inside the report?

153

What are the types of database schema? : sql server analysis services, ssas

1068

What is the index requirement in SQL Azure?