Gerry, 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? Thanks, Jeff