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 are the components of dbms?

0 Answers  

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

What is a schema in ms sql server 2005?

0 Answers  

How to drop an existing user defined function in ms sql server?

0 Answers  

Explain about SQL server 2005?

0 Answers  

write the query for taking database restore in sql?

2 Answers  

What happens when converting big values to integers?

0 Answers  

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

What is temporal data type?

0 Answers  

Name few of the dcl commands in sql?

0 Answers  

How do I run a trace in sql server?

0 Answers  

How to invoke a trigger on demand?

0 Answers