The clause to combine JOIN data in SQL
in sql, the join clause is used to combine records from two or more tables in a database using common values from each table.
Tags : join sort in sql
LEFT JOIN in SQL
the left join in sql is the type of join that returns all records from the left table and matching records from the right table.
RIGHT JOIN in SQL
right join in sql is a type of join that returns all records from the right side table and matching records from the left side table.
FULL JOIN in SQL
full join in sql returns all records in the left table and the table must combine and fill in that null values for values do not match.
SELF JOIN in SQL
each join operation must have two tables, but there are cases where you have to perform join on the same table, but you can call this join operation self join.
CARTESIAN JOIN in SQL
cartesian join in sql returns the cartesian product of record sets from two or more combined tables.