The documentation is incomplete.
Querying joins over multiple tables does not work correctly in SQLite.