HOW MANY TYPES OF JOINS AVAILABLE IN SQL SERVER?

Answer:

There are Five type of joins available in sql server

1) INNER JOIN
There are Two tables having Common column values go with inner join.
2) OUTER JOIN(LEFT OUTER JOIN,RIGHT OUTER JOIN)
Left outer join: Taking Left side of the values checking in to Right side Taking Right side values checking with left side call right outer join.
3) FULL JOIN
Full join combined with left outer join and right outer join.
4) CROSS JOIN
Cross join is an Cartesian Product.its look matrix format.
5) SELF JOIN
join within the table is called self join..