Solved

Incorrect syntax near the keyword 'WHERE'

Posted on 2007-12-06
3
162 Views
Last Modified: 2010-03-20
I'm just not seeing it...probably because I have a headhache:


SELECT	st.iStudentID,

			clp.iProjectID,

			clp.vchTitle,

			cpop.iClassProjectID,

			cl.siLessonNumber,

			st.vchUserName,

			st.vchFirstName,

			st.vchLastName,

			st.bEnabled,

			cse.iClassEnrollID

	FROM Student st (nolock)

		JOIN Class_StudentEnroll cse

		JOIN Student_Program sp ON sp.iStudentID = st.iStudentID

		JOIN vClassProgramOutcomeProjects cpop ON cpop.iProgramID = sp.iProgramID

		JOIN ClassLessonProject clp ON clp.iProjectID = clgp.iClassItemID

		JOIN ClassLesson cl ON cl.iClassLessonID = clp.iClassLessonID

		JOIN classGradePoint clgp ON clp.iClassLessonID = cl.iClassLessonID

		JOIN ClassLessonProject clp ON clp.iProjectID = clgp.iClassItemID

	WHERE ((cse.chLetterGrade IS NULL) OR (cse.chLetterGrade <> 'EW'))

		AND cse.bWithdrawn = 0

		AND cse.chEnrollType = 'STU'

		AND cse.iClassID = 9482

Open in new window

0
Comment
Question by:dba123
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
imitchie earned 250 total points
ID: 20423219
SELECT  st.iStudentID,
                        clp.iProjectID,
                        clp.vchTitle,
                        cpop.iClassProjectID,
                        cl.siLessonNumber,
                        st.vchUserName,
                        st.vchFirstName,
                        st.vchLastName,
                        st.bEnabled,
                        cse.iClassEnrollID
        FROM Student st (nolock)
                JOIN Class_StudentEnroll cse   ------- join condition needed here
                JOIN Student_Program sp ON sp.iStudentID = st.iStudentID
                JOIN vClassProgramOutcomeProjects cpop ON cpop.iProgramID = sp.iProgramID
                JOIN ClassLessonProject clp ON clp.iProjectID = clgp.iClassItemID
                JOIN ClassLesson cl ON cl.iClassLessonID = clp.iClassLessonID
                JOIN classGradePoint clgp ON clp.iClassLessonID = cl.iClassLessonID
                JOIN ClassLessonProject clp ON clp.iProjectID = clgp.iClassItemID
        WHERE ((cse.chLetterGrade IS NULL) OR (cse.chLetterGrade <> 'EW'))
                AND cse.bWithdrawn = 0
                AND cse.chEnrollType = 'STU'
                AND cse.iClassID = 9482
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20423220
check the ----- line above ^^^
0
 
LVL 1

Author Comment

by:dba123
ID: 20423226
crap...thanks.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now