Please help me writing the sql query, to return total numbers of THREADS and POSTs for each forum. I have 3 tables-
1) FORUM [ForumID,Title,Description]
2) THREADS [ThreadID,ForumID,Title,Description]
3) POSTS [PostID,ThreadID,Description,postedOn]
So you can easily identify the relationship in these tables.
I want result as below:
--------------
FORUM Title No of Threads No of POSTS Last Post
<F1> 10 50 <date>
<F2> 100 5 <date>
-----------------
Please suggest the SQL query.
Thanks
1) FORUM [ForumID,Title,Description]
2) THREADS [ThreadID,ForumID,Title,Description]
3) POSTS [PostID,ThreadID,Description,postedOn]
So you can easily identify the relationship in these tables.
I want result as below:
--------------
FORUM Title No of Threads No of POSTS Last Post
<F1> 10 50 <date>
<F2> 100 5 <date>
-----------------
Please suggest the SQL query.
Thanks