Get Last Posts Of A Group Users

Hello dear coders

I have two tables (Members and Blogs)

I want to get the last posts of my user group 2 for each user i want to see this sentences

i-developer : last post on 5 May 2007 at 3.55 am
kingalone: last post 0n 6 June 2007 at 400 am

so i tried a lot of sql queries but none of them succed

my codes are;




SELECT Members.Username, Blogs.IsPublished, Blogs.PublishedDate

FROM Members INNER JOIN

Blogs ON Members.MemberID = Blogs.MemberID

WHERE (Members.RoleID = 2)

ORDER BY Blogs.EntryID

group by Username

select Max(EntryID),MemberID from Blogs where RoleID = 2

with FilteredLastPost ( MemberID,EntryID,PublishedDate)

as

(

select MemberID,EntryID,PublishedDate from Blogs where IsPublished = 1 and MemberID in( (select MemberID from Members where RoleID = 2)) order by EntryID desc, MemberID asc

)

select MemberID from FilteredLastPost

select distinct Blogs.MemberID,EntryID,PublishedDate from Blogs

right join Members on Members.MemberID = Blogs.MemberID

where not PublishedDate ='' and IsPublished = 1 and Members.RoleID = 2

order by EntryID desc, PublishedDate desc









select DISTINCT MemberID, EntryID, PublishedDate DISTINCT IsPulished from Blogs where IsPublished = 1 and not PublishedDate ='' and MemberID in ( select MemberID from Members where RoleID = 2 )