asked
Average the students grade and show only that student on a different table?
Peace, Ok, so i have added the grades (For ex. Student_ID=3) of first_semester_Avg and second_semester_Avg and have the Total_average of those as well. My problem is that i don't know how to show that specific student (ID=3) with his average from all the subjects and show that on a different table. I mean i just want that one student with all his grades of Total_Avg added up and divided by how many grades there. And different classes have different number of subjects. Code I have tried: SELECT Grades.*, Students.First_Name, Students.Last_Name, Subjects.Subjects, Students.Student_ID, * FROM Subjects INNER JOIN (Students INNER JOIN Grades ON Students.Student_ID=Grades.Student_ID) ON Subjects.Subjects_ID=Grades.Subject_ID WHERE (((Students.Student_ID)=[Enter a Student ID])); I have written so many different codes and nothing works the way i want. Any help ?![alt text][1] Table Structure: ![alt text][2] [1]: /storage/temp/1244-totalavg.png [2]: /storage/temp/1248-1246-relationship.png
SELECT Grades.*, Students.First_Name, Students.Last_Name, Subjects.Subjects, Students.Student_ID, * FROM Subjects INNER JOIN (Students INNER JOIN Grades ON Students.Student_ID=Grades.Student_ID) ON Subjects.Subjects_ID=Grades.Subject_ID WHERE (((Students.Student_ID)=[Enter a Student ID]));
this pic is the design view of the code up:![alt text][1] [1]: /storage/temp/1247-joinq.png
14 People are following this question.
