SQL

8 type of joins(Italicized joins doesnt have built-in sql syntax) :

1. Inner join
2. Self join (special case of inner join)
3. Left join ( An outer join)
4. Right join ( An outer join)
5. Full join ( An outer join)
6. Cross join
7. Semi join
8. Anti join