The relational join operation merges rows from two tables and returns the rows with one of the following conditions:

The relational join operation merges rows from two tables and returns the rows with one of the following conditions:

• Have common values in common columns (natural join)
• Meet a given join condition (equality or inequality)
• Have common values in common columns or have no matching values (outer join)

Discuss the differences between these three conditions and give examples of each.