Well in my Forum, i want to make topics and in the home page, show the user how many threads and posts in each topic, my DB For threads Contains 3 tables:

  • Topics(TopicID, Title)
  • Threads(ThreadID, TopicID)
  • Posts(PostID, ThreadID)


sure that's not all, but that wt i need to view this, so i tried the group by with Only topics and threads and it worked pretty fine, but cant make it with the Posts, so any help please?!