Hi Frank,
Thank you for the help and example you included in your reply.
With the help gained by all that answered I concocted this work around which
works perfectly.
I have included the code to help anyone else who needs this kind of result.
It has two table references
the first gets admin da
Hi Dave,
The easiest, most direct, ANSI - SQL way to do what you ask is:
SELECT count(*) as num_posts, Admin_id
FROM <>
WHERE <>
GROUP BY Admin_id
ORDER BY Admin_id
This will give you:
num_posts Admin_id
-
3 1
4 2
5 3
And naturally you