Skip to content
Advertisement

Call an alias in a case expression

I have this code that is to check each month to see if the person is enrolled in that month and at the end it is suppose to tell you if the person was enrolled for the whole year or not. The Annual is to check each month to see if they have a 1 from the case expression. The issue is I can’t get SQL to recognize the alias names like Jan and Feb

Advertisement

Answer

Try this:

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement