I want to use the result of this query inside angular and render the result in the browser. The query is:
SELECT Student.Name, Student.Surname,Student.Major,Subject.Name,Grades.Grade
FROM Grades
INNER JOIN Student
on Grades.StudentId = Student.Id
INNER JOIN Subject
on Grades.SubjectId = Subject.Id
I only know the simple $http.get(url).then(function())...to render one single table, but don't know how to render the join of three related tables. Please help!