Reply to Re: problem with count, group by and ntext
Posted by Igor on 04/10/06 12:57
I wrote it like this:
SELECT projects.project_id, projects.project_title,
projects.project_description, (SELECT count(*) FROM users WHERE
projects.project_id=users.project_id) AS number_od_users
FROM projects;