now am using to tables one forums and response this table using inner join query but repeated response display..
how handle this problem
am post in one forum and then response for two ro three peoples. but display in one time.. now only displayed in more times this query..
select F.forumID,F.Author,F.forumTitle,F.forumDesc,F.Category,F.Points,F.Images,F.Dateofpost,Convert(VARCHAR(10),F.Dateofpost,101) as Jdate from tblForum F inner join tblForumResponse s on F.forumID=s.forumID where Status='Approved' order by s.Dateofpost desc
Advance thanks to all