Click here to Skip to main content
15,905,144 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
SQL
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
Posted
Updated 25-Jan-16 22:17pm
v2
Comments
[no name] 26-Jan-16 4:18am    
Provide a demo example with table data. Because we do not what data is stored in your tables.
Sinisa Hajnal 26-Jan-16 4:33am    
change the query to SELECT *
comment out all except first table and then start uncommenting
You missed one extra condition in on clause somewhere
subjects -> classes or subjects -> teacher or something

1 solution

No one can see your data so we can't possibly know why you are getting duplicate data. Perhaps its in your joins. It could be in your WHERE clause. Or, it could be your database has duplicate data.

However, follow Sinisa's advice and start by commenting out some of your joins until you find where the duplicates are coming from.

And if you are actually using DISTINCT then no, you are not getting duplicate data, at least not the entire row.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900