Hello.
What do you think about this:
SELECT u.name,
IFNULL(s.skill_name,'user doesn\'t have any
skill') AS SKILL,
(
SELECT COUNT(skill_id)
Thanks to all that responded about my counting question. Gleb
Paharenko's solution using the sub-select and the LEFT JOINS was the
closest to what I needed.
All the best,
Dean...K...
--
Dean Karres / karres at itg dot uiuc dot edu / www.itg.uiuc.edu
Imaging
Try this out:
select user.name, skill.skill_name, count(user_skill1.skill_id)
from user , skill, user_skill , user_skill as user_skill1
where user.id=user_skill.user_id and user_skill.skill_id=skill.id and
skill.id = user_skill1.skill_id
order by user.id.
I think this would work.
--
Parag
I could not help to resist to create the tables and
try the hint, which is pretty close to the working
solution.
I just had to replace order by user.id with group
by user.name skill.skill_name
regards,
esv.
--- Parag Agrawal [EMAIL PROTECTED] wrote:
Try this out:
select user.name,
Try this:
select delivery, count(*) as ticketcount
from ticketsales
where delivery=post or delivery=pickup
group by delivery
Andy
-Original Message-
From: Ville Mattila [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 11:28
To: [EMAIL PROTECTED]
Subject: Counting question
Hi there,