Generalization of natural join
- You can read about them (e.g. in the textbook).
-
- Instead of comparing columns using equality, use some other
comparison.
- Because the compared columns don't always match in value,
keep both columns.
- Completely useless.
- I don't know of optimizers that do anything special for them.
- Further generalization: Any predicate.
|