Re: select statement with count

[Peter Brawley]

select u.name, x.N as theCount
from users u 
join (
  select u.id, count(d.userid) N
  from users a
  left join userdocs b on a.id=b.userid
) x using(id);