Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Using Count on 'Joined' tables
July 12, 2006, 10:51 am
rate this thread
I have two tables, pages and sections, of which pages are a subset of
sections. I'm listing out the sections in a list and want to include a
COUNT of how many pages each section has within it.
Pages contain a 'sectionid' field to join it to the 'id' in the seciton
table but im unsure how to join, and group to get a count of the
number of pages in each section (i.e. in each result row)
If anyone can point me in the right direction, id be eternally greatful