ALTER PROCEDURE [dbo].[usp_rpt_evaluation] @class_id tinyint AS BEGIN select distinct tbl_Learners.learner_name, tbl_Subjects.Subject_name, tbl_Subjects.Subject_id, tbl_Teachers.teacher_name, tbl_Transactions.degree, tbl_Transactions.letter, tbl_Transactions.comment_text, tbl_AbsenceTardiness.absence_days, tbl_AbsenceTardiness.Tardiness from tbl_Learners inner join tbl_classes on tbl_classes.class_id=tbl_Learners.class_id inner join tbl_Teacher_Classes on tbl_Teacher_Classes.Classroom_id=tbl_classes.class_id inner join tbl_Teachers on tbl_Teachers.teacher_id=tbl_Teacher_Classes.teacher_id inner join tbl_Subjects on tbl_Teachers.subject_id=tbl_Subjects.Subject_id left join tbl_Transactions on tbl_Learners.learner_id=tbl_Transactions.learner_id left join tbl_AbsenceTardiness on tbl_Learners.learner_id=tbl_AbsenceTardiness.learner_id where tbl_Learners.class_id=@class_id and tbl_Teacher_Classes.Classroom_id=@class_id order by 3 END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)