SQL If NOT EXISTS Syntax error

Question

IF NOT EXISTS (SELECT prereqListID
               FROM   dbo.tblPreRequisiteList
               WHERE  NOT prereqListID IN (SELECT FK_prereqID
                                           FROM   dbo.tblPreReqStudentAnswers
                                           WHERE  FK_applicantID = @appID))

I have a syntax error in this statement that I can't seem to identify.

Any thoughts?

Thanks for your time.

Also please state RDBMS. For some reason I assumed SQL Server. dbo.tblPreRequisiteList makes that look a reasonable assumption but please clarify. — Martin Smith
– Martin Smith, Commented Nov 20, 2013 at 20:09

Martin Smith · Accepted Answer · 2013-11-20 20:01:51Z

2

Executing the code in the question will give the error

Incorrect syntax near ')'.

You need to follow it with another statement/block

IF NOT EXISTS (SELECT prereqListID
               FROM   dbo.tblPreRequisiteList
               WHERE  NOT prereqListID IN (SELECT FK_prereqID
                                           FROM   dbo.tblPreReqStudentAnswers
                                           WHERE  FK_applicantID = @appID))
BEGIN
SomethingHere:
END

answered Nov 20, 2013 at 20:01

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL If NOT EXISTS Syntax error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related