DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- MS SQL (http://www.daniweb.com/forums/forum127.html)

- - Types of JOINS (http://www.daniweb.com/forums/thread121813.html)

mansi sharma

Apr 30th, 2008 4:52 pm

Types of JOINS

1) INNER JOIN---I know

2)OUTER JOIN--I know

3)CROSS JOIN--I know

4)THETA JOIN--????

5)SELF JOIN--??????

6)NATURAL INNER JOIN- It eliminates attributes that have the same name.
Can u plz frd me the example of NATURAL INNER JOIN.
cz its not working in SQL 2005.

7) EQUI JOIN----??????

Your EArly Reply will be HIGHLY APPRECIATED.

ardeezstyle

May 8th, 2008 9:33 am

Re: Types of JOINS

Visit this link you may be benefited...
http://www.answers.com/topic/join

All times are GMT -4. The time now is 4:04 am.