Table Joins

Oracle PL/SQL joins are a way to combine data from multiple tables into a single result set. Below are a list of pl/sql joins that you can use to learn some basic rules about joins.

INNER JOIN

Inner Join – The most common type of join is the inner join, which returns only rows that match in both tables.

LEFT JOIN

Left Join – Left and right joins are variations on the inner join. A left join returns all rows from the left table, even if there are no matches in the right table.

RIGHT JOIN

Right Join – A right join returns all rows from the right table, even if there are no matches in the left table.

SELF JOIN

Self Join – Self joins are a type of join that joins a table to itself. This can be useful when you need to compare data in a single table, such as finding employees who have the same job title.

FULL JOIN

Full Join – Full joins return all rows from both tables, even if there are no matches in either table. This can be useful when you want to see which values in one table are not present in another table.