Joins

• Equi-Join: A special case of condition join where the condition c contains only equalities and ^.

S1 sid R1

• Result schema similar to cross-product, but only one copy of fields for which equality is specified.

• Natural Join: Equijoin on all common fields.

Previous slide

Next slide

Back to first slide

View graphic version