SQLite Forum

Not understanding a subquery - Some guidance?
> but can someone explain why this query doesn't work?

But it does work, exactly as coded.

The descent condition specified is True for every combination of r and t tuples so the result is, as expected, the cross join of those two tables.