There are four basic types of JOINS – Inner, Outer (left, right, full), Self and Cross join. An inner join…
DB2 Join: An INNER JOIN finds and returns matching data from tables, while an outer join finds and returns matching data…