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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.