Join

• Most often used…

• Combines two relations, selecting only related tuples

• Equivalent to a cross product followed by selection and projection

• 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