+0 -0
The types of join in DBMS are:
Inner Join: returns only the rows that have matching values in both tables.
Left Join (or Left Outer Join): returns all rows from the left table and the matching rows from the right table. If no match is found, the result will contain NULL values.
Right Join (or Right Outer Join): returns all rows from the right table and the matching rows from the left table. If no match is found, the result will contain NULL values.
Full Outer Join: returns all rows from both tables, including the ones with no matches. If no match is found, the result will contain NULL values.
Cross Join: returns the Cartesian product of both tables, which is the combination of every row from the first table with every row from the second table.