The JOIN operation allows you to combine rows from two or more tables based on a related column. OUTER JOIN…
DB2 Join: An INNER JOIN finds and returns matching data from tables, while an outer join finds and returns matching data…