CODEWITHSUNDEEP
sqljoin
G. M. Nazmul Hossain
G. M. Nazmul Hossain

Reputation: 466

How many join have in SQL?

I am using inner join, left outer join, right outer join and full join in SQL. is there have any other type of join in SQL?

Upvotes: 1

Views: 1463

Answers (2)

polerto
polerto

Reputation: 1790

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

Upvotes: 2

Oded
Oded

Reputation: 499212

There is also the cross join and self join.

The wikipedia article on joins is quite good.

Upvotes: 2

Related Questions