Different types of joins

[Yogesh Sharma]

I know the bolded part,tell me the descriptions abt the others.

1) INNER JOIN
2)OUTER JOIN
it is further of two types-
a)LEFT OUTER JOIN
b)RIGHT OUTER JOIN


3)CROSS JOIN-----????????

4)EQUI JOIN--Where the comparison operator used is only equal to. Am I right?? Give me eg plz.

5)NATURAL INNER JOIN--It eliminates the attributes that have the same name. Give me eg plz.

6)THETA JOIN----???????????

7)SELF JOIN--?????????????

[amitpatel66]

Your question is too theoritical and is out of scope to be discussed in this forum. Please refer some good SQL book or web for answers.

MODERATOR

[dhutton]

I agree. There are some pretty good books on this subject.

[debasisdas]

1)CROSS JOIN-----it generates a cross product.

2)THETA JOIN----join that involvs an equality(< or >).

3)SELF JOIN--the table is joined to itself

Refer any good book for details.

[Yogesh Sharma]

Thx.Can somebody tell me the good book of SQL.

[ck9663]

Try google :)

Just type sql server followed by what you're looking for. In this case join

-- CK