18-10-2016, 15:49
TRANSFORM Sum(Talebe_Grade.EOY) AS Notlar
SELECT Talebe.ID, [FirstName] & " " & [LastName] AS AdSoyad, ConstantData.tr AS Dersler
FROM (Talebe INNER JOIN Talebe_Grade ON Talebe.ID = Talebe_Grade.Student) INNER JOIN ConstantData ON Talebe_Grade.Lesson = ConstantData.ID
GROUP BY Talebe.ID, [FirstName] & " " & [LastName], ConstantData.tr
ORDER BY "Sınıf" & [Grade]
PIVOT "Sınıf" & [Grade];
=====
yukaridaki query acceesde hazirladim ama aynisini sql express de yapamadim. Bilen arkadaslar yardimci olabilirler mi
SELECT Talebe.ID, [FirstName] & " " & [LastName] AS AdSoyad, ConstantData.tr AS Dersler
FROM (Talebe INNER JOIN Talebe_Grade ON Talebe.ID = Talebe_Grade.Student) INNER JOIN ConstantData ON Talebe_Grade.Lesson = ConstantData.ID
GROUP BY Talebe.ID, [FirstName] & " " & [LastName], ConstantData.tr
ORDER BY "Sınıf" & [Grade]
PIVOT "Sınıf" & [Grade];
=====
yukaridaki query acceesde hazirladim ama aynisini sql express de yapamadim. Bilen arkadaslar yardimci olabilirler mi
