95
Eq-join
•
A theta join where
q
is an equality
•
R1
⋈
A=B
R2
=
s
A=B
(R1
´
R2)
•
Example:
–
Employee
⋈
SSN=SSN
Dependents
•
•
Most useful join in practice