Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esambath
Yak Posting Veteran
89 Posts |
 Posted - 2008-10-15 : 08:43:11
|
| Hi Friends,I have four table named as below, and please find the fields also.From the Category table I have to display the category name and from the request table I have to get the count of request for the particular category. And from the request reply table I have to count the number of request reply, and I want to display who is posted last.KR_UserManagementUserIdNamePasswordKR_categoryCatIdNameDescriptionParentidKR_RequestReqIdCatIdUserIdReporterId [Reply User id]TopicDescriptioncreatedDateTimeKR_RequestReplyRepIdReqIdUserIdTopicDescriptionExpected output structure is[CategoryName] [RequestCount] [RequestReplyCount] [LastPostUser]Thanks and RegardsE.sambath kumar |
|
|
|
|
|
display forums List query