KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a stored procedure in which i am trying to select all the columns of a table Table 1. There is another table which uses Table1 primary key as foreign key. I want to count number of records in this foreign key table with that select like this: SELECT *, count(*) VacancyCount FROM Table1 hc LEFT JOIN Table2 hv on hc.CompanyID = hv.CompanyID WHERE hc.Deleted = 0 group by hc.CompanyID ORDER BY NameLang1 but it gives error: Column 'dbo.Table1.NameLang1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Please suggest how to fix this?
Tags (comma-separated)
Save Edits
Cancel