Hacker News new | ask | show | jobs
by andreareina 2406 days ago
Any reason a regular count() wouldn't work?

SELECT a.id, count() FROM ...
1 comments
Svip 2406 days ago
It would, I realised after I read the replies, that I should have used the two joined table scenario as per my reply to your sibling.
link