Table view not filtering

HI,

I have a table view. see sql script below

CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECURITY DEFINER VIEW studentenrollmentview8 AS select s.student_id AS student_id,s.student_firstname AS student_firstname,se.enrollment_id AS enrollment_id from ((bz_sas_student s left join bz_sas_class c on((s.student_id = c.student_id))) left join bz_sas_student_enrollment se on((c.enrollment_id = se.enrollment_id)))

I have enrollment, student, class and grade table. My issue is when I create the enrollment/s and add student to the class table then move to the grade table upon selecting the student from my drop down select, I get the list of ALL students from the different enrollments. I think it should only display the student for that specific class and enrollment.. see below image. In this example only Billy, Jonathan and Larry suppose to appear.

https://snipboard.io/VGEuha.jpg

See below relationship

https://snipboard.io/uksSOq.jpg

Regards,

Ian

• This topic was modified 2 years, 3 months ago by ijtzib.