Differences between cross join, left join, right join, full join, and inner join in SQL

 Cross join Is the product of flute Is the number of rows in one table multiplied by the number of rows in the other table.
Left join The connection column of the First table does not match in the second table,The value in the second table is returned.Null
Right join The join column of the second table does not match in the first table,Returns the value of the first table.Null
Full join Returns the rows in two tables.Left join + right join
Inner join Returns matching items for only two table connection columns.