SQL Server join

Left join: returns all records in the left table and records with the same connection fields in the right table.

Right join: Right join. All records in the right table and records with the same connection fields in the left table are returned.

Inner join: An inner join, also called an equivalent join, returns only rows with the same connection fields in two tables.

Full join: Outer Join. the rows in the two tables are returned: left join + right join.

Cross join: The result is a Cartesian product, that is, the number of rows in the first table multiplied by the number of rows in the second table.