|
|
Posted by Igor on 06/19/18 11:44
I have one SELECT statement that needs to return one ntext field from
one table and count something from other table, problem is that all
fileds that are not in count have to be in group by and ntext can't be
in group by... i hope you understend what i want to say here :), so is
there any solution to this problem or what is the best workaraund you
would use?
example:
TABLE projects
project_id int
project_title nvarchar(50)
project_description ntext
TABLE users
user_id int
project_id int
SELECT projects.project_id, projects.project_title,
projects.project_description, count(users.*) AS number_od_users
FROM projects LEFT JOIN users ON projects.project_id=users.project_id
GROUP BY projects.project_id, projects.project_title,
projects.project_description;
this select is something that would work for me...if it wasn't for that
tiny problem with ntext field
Navigation:
[Reply to this message]
|