I'm afraid that doesn't make things any clearer. Remember, I can't see these tables and I don't know what you want for a result. The words you are using aren't making it at all clear. One thing you said in your first post was the word "recent", which also appears in a table alias, yet there doesn't appear to be any logic in the query to examine a date or datetime field. When that kind of ambiguity exists, I have to go back to the original poster and ask for very specific details. Be complete and spell it out with every necessary detail. Provide table create statements for the tables involved, and provide sample data for the contents of the tables, so that we have some shot at helping you. As we can't just pick up the phone and call you, you need to work a little harder in explaining what your task is, and what the exact conditions are that the solution must meet.