WHERE GLNAMES.LEVEL_DEPTH = 1
OR GLNAMES.LEVEL_DEPTH = 4
101 GENERAL FUND - CITY
1010100 FM-CHIEF FINANCIAL OFFICER
Is there a way to create a SQL which would have four columns that would have the data returned as:
Acct_Unit Description Acct_Unit Description
101 GENERAL FUND - CITY 1010100 FM-CHIEF FINANCIAL OFFICER
I tried a SQL SELECT within a SELECT and I did not return the correct descriptions.