Combine these 2 statements

Question

0.00/5 (No votes)

See more:

Hello, I am try to combine 2 statements but have the first one's options limited by the second ones results. If the last statement is true I don't want '12' to be an available option in the drop down.

1) SELECT payment_plan.payment_plan_cde, payment_plan.pay_plan_desc
FROM payment_plan
Where payment_plan.payment_plan_cde in ('TF','12')

and

2) SELECT student_term_sum.hrs_enrolled
FROM student_term_sum
WHERE student_term_sum.id_num = @@HostID and student_term_sum.yr_cde = '2018' AND student_term_sum.trm_cde = '20' and student_term_sum.hrs_enrolled > 0

What I have tried:

I haven't tried any combination as of yet but I am not very good with complex SQL so I figured I better reach out for a little help.

Posted 4-Jun-18 16:02pm

Moses Minor

Updated 5-Jun-18 0:40am

Add a Solution

Comments

CHill60 5-Jun-18 4:09am

"If the last statement is true" ... what last statement? The 2nd SQL returns a number. Please try to make your problem clear

Moses Minor 5-Jun-18 7:05am

Sorry, here is what I am trying to do. If (SELECT student_term_sum.hrs_enrolled
FROM student_term_sum
WHERE student_term_sum.id_num = @@HostID and student_term_sum.yr_cde = '2018' AND student_term_sum.trm_cde = '20' and student_term_sum.hrs_enrolled > 0) returns null then I don't want '12' to be an option for this statement (
1) SELECT payment_plan.payment_plan_cde, payment_plan.pay_plan_desc
FROM payment_plan
Where payment_plan.payment_plan_cde in ('TF','12')).

So I want option '12' to be based on if the other statement results in a null

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2018-06-05T00:42:00

Since your send query only returns a single field (possibly with many values?), look into subquery[^] formulated much like below:

SQL

SELECT * FROM Table1 WHERE field1 NOT IN (SELECT field2 FROM table 2)

There are variations on this and, under appropriate conditions (only return a single value from a single field) they can be in your SELECT as well.

Leaning more SQL and it gets easier to write: Certain tasks were so useful they were made into language features.