SQLite Forum

Not understanding a subquery - Some guidance?
Thanks Keith for your reply.

My hope was to join r to t and pull the first t (if any) joining by ritm in both tables.  Does that clarify what I was expecting?  Obviously what i got was the joined rows regardless of limit clause.

Hopefully I've clarified what I thought the result would be.