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.