Join
A binary operation on relations
Result is a whole relation
- All the columns of R1 followed by all the columns of R2
General description: a ? followed by a ?.
- The ? condition equates or otherwise relates common attributes between the two relations
- Often a superfluous common attribute is removed