Answer / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

Answer / mpg

There are 5 types of join in sql server 2005

inner join
outer join
cross join
equi join
self join

Answer / rupinder kaur

there are five types:
inner join
outer join: left outer join,right outer join, full outer
join
equi join
cross join self join

Answer / kalyana chakravarthy maddipati

Apart all the joins above there is one more join it is

NO EQUI JOIN ie emp.deptno!= dept.deptno or one can use <> sign instead

Answer / vishal

1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join

Answer / abi

Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join

Answer / g.ramesh

Inner Join
Outer Join
Crros Join

Answer / kittu

inner join
outer join
cross join
equi join
self join

Answer / g.ramesh

Inner Join
Outer Join
Crros Join

What is user-defined inline table-valued function?

0 Answers  

Is foreign key a primary key?

0 Answers  

How to write a query with a right outer join in ms sql server?

0 Answers  

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

What is row-level compre?

0 Answers  

What is join query?

0 Answers  

List the types of recovery model available in sql server?

0 Answers  

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

What is a result set object returned by odbc_exec()?

0 Answers  

What's the difference between a primary key and a unique key?

4 Answers  

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

0 Answers  

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers