You're right on with the small correction of the joining criteria at the bottom is WHERE instead of ON.

Works perfectly!!!

Hmmmm. Since I don't fully know what you've done, I'm having a hard time plugging this into the situation I need it to work within. I am actually...

What the SQL wizardry?!?! I'm still trying to figure out what you did there, but it works. I've been able to apply the logic to my specific...

Thank you. I'd love a simple query if there is one. That'd be way better. I just couldn't see how to do this without some sort of...