New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
My Current Results
SELECT distinct s.student_number as StuNum, case when sts.testscoreid = '301' THEN sts.numscore else null end as EBRW_Total, case when sts.testscoreid = '120' THEN sts.numscore else null end as Math_Total, case when sts.testscoreid = '122' THEN sts.numscore else null end as Total_Score FROM students s LEFT JOIN StudentTestScore sts ON sts.StudentID = s.ID LEFT JOIN StudentTest st ON sts.StudentTestID = st.ID LEFT JOIN Test t ON st.TestID = t.ID WHERE s.student_number = '12345' AND t.Name = 'SAT' AND sts.NumScore > 0
StuNum,EBRW_Total,Math_Total,Total_Score 12345,,,1010 12345,,450, 12345,560,, 12345,,,,
Join the community of 500,000 technology professionals and ask your questions.