Thank you so much, Johan. I really appreciate your help.

I have another join question for you SQL pros. The query below produces the accurate result set, but I'm guessing the syntax isn't up to current standards. Should...

Yes, this is perfect, thank you. The second inner join was on deedcode, but with that change it works exactly the way I need it to.

Thanks so...

Will do - thanks

You guys are having way too much fun at my expense. I moved the question to the "General" forum; posted to this forum by mistake. What can I...