How to use subselect in a case statement

5 pts.
Tags:
CASE statement
SQL
SQL Subselect
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#

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following