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;

what does "coalesce" do?

• Next in forum: Re: problem with count, group by and ntext
• Prev in forum: Re: Saving .mdf database
• Thread view: Re: problem with count, group by and ntext

[Reply to this message]