I need some help with CASE syntax. I think I need to use CASE here, I'm open to any other suggestions. Here's the basic problem. I've got two tables: GLAccounts and GLDetails.
GLAccounts : GLAcctID, PCNum, AcctNum, AcctType, . . .
GLDetails : GLDetailsID, GLAcctID, Balance, . . .
I want...