Notice Something Missing?
This is typical of relational languages
Some fairly natural queries are impossible
- “Find all the children of X” -- no problem
- “Find all the grandchilden of X” -- still OK
- “Find all the descendents of X” -- no way!
- This is an example of a "transitive closure"
Solution: embed the query in a procedural language (COBOL, C, etc).