How can I use the Venn diagram joins in SQL for retrieval of data?

 In the context of SQL, the Venn diagram is used to retrieve data by using different logical combinations such as INNER, OUTER, LEFT and RIGHT joins.

Here is the explanation given of each join which is mentioned above:-

Inner joins

This is used when there is a match in both tables:-

SELECT *

FROM table1

INNER JOIN table2 ON table1.column = table2.column

Left joins

It is used in the retrieval of data from the left side and matching the rows from the right table.

SELECT *

FROM table1

LEFT JOIN table2 ON table1.column = table2.column

Right joins

It is used in the retrieval of data from the right side and matching the rows from the right table.

SELECT *

FROM table1

RIGHT JOIN table2 ON table1.column = table2.column

Outer joins

It is used as a combination of both left and right joins. This captures all rows from both the tables and then aligns the matches.

SELECT *

FROM table1

FULL OUTER JOIN table2 ON table1.column = table2.column