How many join have in SQL?
I am using i开发者_开发问答nner join, left outer join, right outer join and full join in SQL. is there have any other type of join in SQL?
There are various types of "joins" but some of them are the same type with just different names. http://en.wikipedia.org/wiki/Join_%28SQL%29
There is also the cross join and self join.
The wikipedia article on joins is quite good.
精彩评论