16
Natural Join
•
Notation: R1
⋈
R2
•
•
Meaning:
R1
⋈
R2 =
P
A
(
s
C
(R1
´
R2))
–
•
Where:
–
The selection
s
C
checks equality of all common
attributes
–
The projection eliminates the duplicate common
attributes