Here there is a syntax error on the semicolon after the bracket

Question

1.00/5 (1 vote)

See more:

SELECT DISTINCT Cid
from Buysfrom
where Bid in (select Bid
              from Buysfrom
			  where Cid=569
			  And Hrs in(select Hrs 
			             from Buysfrom          
	            where Cid=569);

What I have tried:

try to remove it but error appears in another word

Posted 11-Dec-22 7:08am

Noran Azab

Updated 11-Dec-22 8:09am

Add a Solution

Comments

0x01AA 11-Dec-22 13:40pm

You miss one closing bracket ')', simply count opening against closing brackets. And on a first glance you don't need two nested select statements.

Richard Deeming 14-Dec-22 6:52am

Your Hrs in (...) filter doesn't make much sense.

You select a record from the Buysfrom table where Cid=569.

You then check to see if there is a record in the Buysfrom table where Cid=569 and the Hrs column is the same as the current record.

But you know that there is - the current record already matches that condition. The only time you won't get a match is if Hrs is Null.

So your query could be simplified to:

SELECT DISTINCT Cid
FROM Buysfrom
WHERE Bid In 
(
    SELECT DISTINCT Bid
    FROM Buysfrom
    WHERE Cid = 569
    And Hrs Is Not 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)

Dave Kreskowiak · Answer 1 · 2022-12-11T08:09:00

Solution 1

Count how many opening parenthesis you have and how many closing. There's a mismatch.

Posted 11-Dec-22 8:09am

Dave Kreskowiak