Originally Posted by Fou-Lu
Use the original names, not the aliased names in a group by clause.
Then I'll need to stop trying. The CASE/WHENs are looking at one of three different tables, and they don't all have the same column names where the aliased info is being pulled from. One table might have SOFTWARE_ID, another APPLICATION_ID, the other SERVER_ID, then aliasing that as ITEM_ID.
Thank you, so much, for your help. I'll just go with the multiple connections route.