Subquery returned more than one value

Question

0.00/5 (No votes)

See more:

I am using subquery with Inner Join and it is returning 10 rows but i need to match those 10 rows with another table.
How can i do that.

Below is my query.

SQL

SELECT 
  IT.IPTELM MOBILNO,
  TC.CDGACNTN GROUPACCOUNTNO, 
  TC.CDCUSTN CUSTOMERNO, 
  TC.PRCARDN, 
  TC.CARDNO, 
  TC.CRDIND, 
  TC.Limit 
FROM CARDS.DBO.TOTAL_CDBS11801 TC
  INNER JOIN CARDS.DBO.INPARTPF IT ON 
    (SELECT DISTINCT CDCUSTN FROM CARDS.DBO.TOTAL_CDBS11801 WHERE PRCARDN  IN 
      (SELECT PRCARDN FROM CARDS.DBO.TOTAL_CDBS11801 WHERE CARDNO IN (SELECT * FROM #T)
    ) AND CRDIND ='P')  = (IT.IPKIPN)

Any ideas

What I have tried:

Googled to find the solution with subquery using inner joins but could not find any solution

Posted 6-Mar-18 19:11pm

Faran Saleem

Updated 6-Mar-18 19:27pm

Kornfeld Eliyahu Peter

v2

Add a Solution

Comments

Maciej Los 7-Mar-18 3:07am

Too many SELECT's!
Try to decrease the number of SELECT statement and you'll be able to correct your query.

Jörgen Andersson 7-Mar-18 15:56pm

Yes, I can see what you're doing and why it doesn't work, Peter is absolutely right.

Explain in words what you want to achieve and we might be able to help you.

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)

Kornfeld Eliyahu Peter · Answer 1 · 2018-03-06T19:27:00

Solution 1

SQL

(SELECT DISTINCT CDCUSTN FROM CARDS.DBO.TOTAL_CDBS11801 WHERE PRCARDN  IN 
      (SELECT PRCARDN FROM CARDS.DBO.TOTAL_CDBS11801 WHERE CARDNO IN (SELECT * FROM #T)
    ) AND CRDIND ='P')  = (IT.IPKIPN)

What you actually have here is A = B, where A (the select clause) has multiple values... You can not do = (equal) with more than one values in either side...

Posted 6-Mar-18 19:27pm

Kornfeld Eliyahu Peter

Comments

Maciej Los 7-Mar-18 3:07am

Short And To The Point!

Faran Saleem 7-Mar-18 4:22am

No sir, you are wrong the issue here is not with = operator but the subquery. Subquery is returning more than one row that is why it is giving me an error. I have used the In operator aswell but it is giving the same error