Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Incorrect syntax near the keyword 'WHERE'

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
dba123
Asked:
dba123
  • 2
1 Solution
 
imitchieCommented:
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
 
imitchieCommented:
check the ----- line above ^^^
0
 
dba123Author Commented:
crap...thanks.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now