hi..please help.. i have 2 tables tblStudents and tblGrades.
in tblStudents, all details of students and in tblGrades, grades of the students.
column "StudId" is their only common column..
in tblGrades: columns are:
what i want to achieve is to query on both tables with the below output:
StudId Name SubjectCode1 SubjectCode2 SubjectCode3
1 Test, Test 95 97 98
SubjectCodes are fixed.the Data will just depend on tblGrades..if StudId 1 doesnt have record for SubjectCode2, 0 will appear on the column for SubjectCode2
really need this.