I'm thinking I need a case statement but I'm not sure where to put it. So far I have:
CASE WHEN ISNUMERIC(a.grade) = 1 THEN b.GradeType = 'Numeric' else b.GradeType = 'Alpha' End
I have two tables: table A has studentID, class, and grade. Table B has GradeType and Average.
Table A StudentID class grade 125 003 75 456 004 82 854 005 A Table B GradeType Average Numeric 89 Alpha 4
GradeType is either Numeric or Alpha. My problem is some grades are Numeric and some are Alpha so when a grade is Numeric (or Alpha) it needs to also pick up what ever the average is for Numeric (or Alpha). I'm not sure how to accomplish this. I was thinking a case statement should be in either the from in the join or the where clause. If anyone could point me in the right direction. Thanks!