Posted by ll on 12/19/07 23:12

Hi,
I'm working with a SQL statement to select from tables and only return
that which matches the semester AND value of 'N'. The statement below
does return results according to my criteria, but it also returns all
of the other results following the semester criteria that don't have a
value of 'N'.
Thanks for any help you can provide,
Louis
---------------------------------------------

SELECT AMS_CourseCategory.CourseCatDesc,
AMS_CourseCategory.CourseCatID, AMS_Courses.Class,
AMS_Courses.Semester, AMS_Courses.TemplateVersion,
AMS_Courses.YearInProgram, AMS_Courses.CourseID,
AMS_Courses.Class,AMS_Courses.Semester, AMS_Courses.YearTaught,
AMS_ContentOverviewObjectiveOutcome.CourseID,
AMS_ContentOverviewObjectiveOutcome.Objective,
AMS_ContentOverviewObjectiveOutcome.Out1,
AMS_ContentOverviewObjectiveOutcome.Out9,
AMS_ContentOverviewObjectiveOutcome.Out8,
AMS_ContentOverviewObjectiveOutcome.OutP15,
AMS_ContentOverview.Complete FROM AMS_ContentOverviewObjectiveOutcome
INNER JOIN AMS_Courses ON AMS_ContentOverviewObjectiveOutcome.CourseID
= AMS_Courses.CourseID INNER JOIN AMS_CourseCategory ON
AMS_Courses.CourseCatID = AMS_CourseCategory.CourseCatID INNER JOIN
AMS_ContentOverview ON AMS_Courses.CourseID =
AMS_ContentOverview.CourseID WHERE Semester = 'FA-SP' OR Semester =
'FA' OR Semester = 'SP' AND Out8 = 'N' order by AMS_Courses.CourseCatID

[Back to original message]