"Join"
Perhaps the most characteristic operation of the relational model
Challenging to implement efficiently
The idea: a Cartesian product on two relations with common attribute domains, followed by a select based on those attributes.
- especially common: equality match ("natural join")