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. Thanks, Jeff