Hi to all,
As a newbie, I am not able to have the following columns into a datagrid. (see database diagram attached)
(I don't want to select ID columns because users may not be able to identify the students). I don't master JOINS .
Infact I want to select all students from tbl_scores who are in a class(level) called F1A and offer the subject Maths
SELECT SubjectName, ClassName, StudentName, Seq1
FROM Tbl_Scores --etc
WHERE ClassName='F1A' AND Subjectname='Maths'
There should be exactly 10 records selected.
But I get Multiple similar records
Can some help by refering to diagram?