Join

• Most often used…

• Combines 2 relations, selecting only related tuples

• Equivalent to a cross product followed by selection

• Resulting schema has all attributes of the two relations, but one copy of join condition attributes

Previous slide

Next slide

Back to first slide

View graphic version