By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

Different types of joins

P: 40
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--?????????????
Apr 16 '08 #1
Share this Question
Share on Google+
5 Replies


amitpatel66
Expert 100+
P: 2,367
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
Apr 16 '08 #2

P: 28
I agree. There are some pretty good books on this subject.
Apr 16 '08 #3

debasisdas
Expert 5K+
P: 8,127
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.
Apr 16 '08 #4

P: 40
Thx.Can somebody tell me the good book of SQL.
Apr 16 '08 #5

ck9663
Expert 2.5K+
P: 2,878
Try google :)

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

-- CK
Apr 16 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.