joins in Database

[Brackwom]

SQL specifies five types of JOIN : INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER and CROSS. if we can join two tables that will reduce the number of rows needed to be processed by subsequent steps, then our performance will improve.

[jackharry11]

There are different types of joins like inner join, outer join, self join

[dark404]

There are different types of joins like inner join, outer join, self join, cross join, natural join, equi join, non-equi join.

Can you explain it to me in detail.

[dark404]

Join-returns both the tables if their is atleast one match in database of two tabels
Left Join-returns all the left table data even if their is no match with right table
Right Join-returns all the  right table rows only ,even when their is no match in left table rows
Full Join-returns a row when their is match in one table

[f1dark]

There are different types of joins like inner join, outer join, self join,

[dark404]

Following are types of SQL joins:-
Join-returns both the tables if their is atleast one match in database of two tabels
Left Join-returns all the left table data even if their is no match with right table
Right Join-returns all the  right table rows only ,even when their is no match in left table rows
Full Join-returns a row when their is match in one table

really wn informative post 

[ReconEngine]

There are several types of joins in database management systems, including INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, and SELF JOIN. Each type of join has a specific purpose and can be used to combine data from multiple tables based on a common column or set of columns.

For example, an INNER JOIN returns only the rows that have matching values in both tables, while a LEFT JOIN returns all rows from the left table and the matching rows from the right table. FULL OUTER JOIN returns all rows from both tables, with NULL values in the columns where no match is found.
CROSS JOIN returns the Cartesian product of both tables, with each row of one table combined with each row of the other table. SELF JOIN is used to combine rows from the same table based on a common column.