How to use subselect in a case statement
Getting error... "Token EXISTS was not valid...." on case statement...
,case when g.GFGSTS = '2'
and not exists
(select a.GFTSEQ
from GFTP010 a
where a.GFCSQ# = g.GFCSQ#
and a.GFGSTS = '3' )
then count(*) end as Void#
Software/Hardware used:
Software/Hardware used:
ASKED:
January 17, 2008 3:11 PM
UPDATED:
January 17, 2008 5:04 PM
Answer Wiki:
Hi,
It sounds like something isn't implemented in the system you're using. Your code works for me in Oracle 10 and also in SQL Server 2005. What are you using?
There's a faint chance that an error in the code you didn't post is causing the problem. Post a complete SQL statement (as simple as possible) that gets the same error.
If your system really doesn't support this, there may be another way to get the results you want. Describe what you're trying to do; include a few rows of sample data and the results you want to produce from that data.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
