Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.

Join them; it only takes a minute:

Sign up
Join the Stack Overflow community to:
  1. Ask programming questions
  2. Answer and help your peers
  3. Get recognized for your expertise

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!

share|improve this question
    
Are you serious, sql query from UI? it should be there on server side ado.net? why ? and how can angular will help you to make a join? – Pankaj Parkar 38 mins ago
    
Making a query to SQL server is not a feature of Angular. – Claies 35 mins ago
    
You seem to have a misunderstanding of separation of client side vs server side tasks and how database is accessed only from server side programming language – charlietfl 18 mins ago

The preferrable solution will be to have a server side service to return the data from the sql query to angular. Once the data is returned then from angular you are able to extract the contents that you are required to be rendered in the view

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.