case V_WORK_DETAILS.WORK_TIME when s.S_ID =1
Here is the problem.
why you used V_WORK_DETAILS.WORK_TIME here?
Thanks for replying.
I have used 'V_WORK_DETAILS.WORK_TIME' for specifying the column name.
When I tried to run the query by avoiding the column name, it worked fine.
you already used s.S_ID column, so you can't use another column like that.
So is your problem resolved now?
Thanks again for replying.
The issue got resolved now
The Problem was with ''V_WORK_DETAILS.WORK_TIME'. I just removed it and the query worked fine.
There was no issue with the s.S_ID column.
Then close the thread by marking the correct answer