The match operation is a new operation that complements the join operation. Despite the fact that the number of operations in relational algebra is stable and verified over many years, this operation is a continuation of subqueries and joins. It is useful and important in the daily work of a programmer and analyst.

Relational Databases — Matching operation