SQLite Forum

Not understanding a subquery - Some guidance?

Thanks for your reply.

By moving final close parenthesis as you mention I get a single row back.  My hope is to get three rows where the first join would return the most recent row (order by ud desc).  So instead of current getting  5 rows which 4 and 5 are correct but the first three I would only expect 1 (thus the limit 1 clause) so in total I'd expect 3 rows back.

Did this make any sense?