Cross join joins each row of one table with each row of another table. The result of the cross join is a Cartesian product (also called the cross product) of the two.
Self Join is a join where a table is joined to itself. That is, both the tables in the join operations are the same. In a self join each row of the table is joined with itself if they satisfy the join condition
The Full Join (Also known as Full Outer join) includes the rows from both the tables. Wherever the rows do not match a null value is assigned to every column of the table that does not have a matching row. A Full join looks like a Right Join & Left Join combined together in one query. This article explores the Full join in more detail with examples
The Right Join (Also known as Right Outer join) includes all the results from the Right table and includes only the matching rows from the Left table. It is a mirror image of the Left Join. This article explores the Right join in more detail with examples
The Left join (or left outer join) is one of the most commonly used join statement in SQL Server. A join lets us combine results from two or more tables into a single result set. The left join includes all the results from the left table and includes only the matching rows from the right table. This article explores the left join in more detail with examples