The recursive join is an operation used in relational databases, also sometimes called a "fixed-point join". It is a compound operation that involves repeating the join operation, typically accumulating more records each time, until a repetition makes no change to the results (as compared to the results of the previous iteration). In this example, as in many real cases, the repetition involves only a single database table, and so is more specifically a "recursive self-join".