I need to debug this query which is causing us problems and it's been awhile since I've written any SQL. I'll continue to hammer away at this but I'm missing some fundamental concept here and would ...