Answer / uday kumar. a

Two types of joins
1. Inner Join
2. Outer Join
2.a Left outer join
2.b Right outer join

Answer / rajesh v.g.

In SQL Server, we have the following joins
1.Self Join
2.Inner Join
3.Cross Join
4.Outer Join
4.1 Left Outer Join
4.2 Right Outer Join
4.3 Full Outer Join

Answer / shankar

2 types:
1. Inner Join
2. Outer Join
3. Cross Join
1. Inner Join: Inner Join displays matched rows.
2. Outer Join: Outer Join displays matched rows as well as
unmatched rows. Outer Joins again classifed into 3 types.
2a. Left Outer Join: Matched rows as well as left table
unmatched rows.
2b. Right Outer Join: Matched rows as well as right table
unmatched rows.
2c. Full Outer Join: Matched rows as well as left table
unmatched rows and right table unmatched rows.
3. Cross Join: It will display the cartegion product of the
tables.

Answer / suneel reddy

Inner Join
Outer join
self join
cross join

Answer / rk_(processmap)

1)Inner join A join that displays only the rows that have
a match in both joined tables
2)Outer join A join that includes rows even if they do
not have related rows in the joined table
i) Left outer join All rows from the first-named
table
ii) Right outer join All rows in the second-named
table
iii) Full outer join All rows in all joined
tables are included
3)Cross join A join whose result set includes one row for
each possible pairing of rows from the two tables

http://msdn2.microsoft.com/en-us/library/zt8wzxy4
(VS.80).aspx

Answer / giribabu

1)Simple Join
a)Equi join
b)Non Equi-join
2)Self join

3)Outer Join

Answer / smiley

1)Inner Join
- Natural Join
- Cross Join
2)Outer Join
- LEFT Outer Join
- RIGHT Outer Join
- FULL Outer Join
3)Merge Join
4)Hash Join
5)Sort-Merger Join

Answer / hema

equi join
non equi join
left outer join
right outer join

that's it ok......

Answer / knight rider

Types of Joins are:
1.Inner/Simple joins:a)Equi join b)Non-Equi join c)Self join
2.Outer join:a)Left outer join b)Right outer join c)Full
outer join
3.cross join or cartesian product join
4.Natural join

Answer / guest

1. Cartesian Join(product join)
2. Inner Join(Equi join)
3. Outer Join
3.1 Left Outer Join
3.2 Right Outer Join
3.3. Full Join
4. Self Join

How can your reverse a sentence("I LOVE MY COUNTRY" to "COUNTRY MY LOVE I")

4 Answers   ADP,

I attendend written test in NDS bangalore in aug 2009. 20 aptitude and 10 descriptive questions. In aptitude they ask sums from time and work,time and distance,tap,feet and inches(12 inches=1feet),percentage etc...

0 Answers   NDS,

What is system testing? when we use system testing in our project?

2 Answers   Infosys, NSS,

What do u mean by BATCH test?

6 Answers  

What is meant by code walkthrough?

5 Answers  

Expalin about PET model?

1 Answers   AppLabs,

what is exit criteria and entry criteria with proper examples??? hi, i faced so many interwies in this question...so plz answer this questions as early as possible...

1 Answers   Covansys,

Why do we prepare test condition,testcases,testscript?

1 Answers  

What is the difference between unit testing and functionality testing ?

9 Answers   CSS, CTS,

what is Software Development Life Cycle (SDLC)?

1 Answers   iFlex, STC,

Just now i got a bug in the application.Anyone of u can clarify me is it a bug or not. scenario is: 1. if we a check box more than one. 2. click TAB and keep the focus on any check box not on the last check box 3. Then click (space+tab) at a time 4. then check the changes if we click anywhere the previous check box is going to be checked and the application is going to be hanged........... please answer to this question.If i have reported this to my developers they are telling that this is a browser property please confirm this scenario at ur developers and answer to me please .thanks in advance........ (glamorous)

2 Answers  

what is scenario????

6 Answers