The Outer Join is an extension of the Inner Join which includes both rows that qualify for a simple Inner Join as well as a specified set of rows that do NOT match the join conditions mentioned in the query. This is the reason sometimes it gets a bit complicated to code the Outer Joins [...]

As discussed previously, in Teradata we have the following types of Inner Joins.  Ordinary Inner Join Cross Join Self-Join Let’s discuss how they are different from each other and how to use them. Ordinary Inner Join: – As you know, JOIN allows you to select common columns and rows from two or more tables/views, similarly [...]