Listing most commented news
Posted
by zurna
on Stack Overflow
See other posts from Stack Overflow
or by zurna
Published on 2010-03-27T15:47:52Z
Indexed on
2010/03/27
15:53 UTC
Read the original article
Hit count: 127
asp-classic
I have two tables in my database.
- Comments
CommentsID MembersID CommentsBy CommentsBy CommentsDesc CommentsActive CommentsDateEntered NewsI
- News
NewsID MembersID CategoriesID ImagesID ImagesID NewsTitle NewsTitle NewsShortDesc NewsDesc NewsActive
I need to take top 5 commented news (active comments and active news) and list their titles using one query. I hope I made sense. But I am really confused here. Any suggestion appreciated.
© Stack Overflow or respective owner