For example, in a non Equi-Join condition you can use !=, <=,>=,<,> or BETWEEN etc. operators can be used for joining. For implementation you can read about Inner-Join. Outer Join: Outer joins are the SQL operations which definitely return all the rows from Source table no matter whether there is a matching join condition hit or not. At the ... Programming, SQL, Exploit the Power of Joins in SQL SELECT Statements, Kevin Forsythe, SQL for eServer i5 and iSeries, Inner joins, outer joins, exception joins, cross joins, as/400, os/400, iseries, system i, i5/os, ibm i, power system, ibm 6.1
Know the exact difference between Inner Join Vs Outer Join with Comparison and Examples. The major differences between inner and outer join in SQL.