spaceworld
New Member
i have a join of 5 Tables to get the tasks posted by each member having about 15 Fields.But for sample code i have taken just two tables of them. \[code\]SELECT top 5 dbo.MemberMst.MemberID, dbo.MemberMst.fname, dbo.TaskMst.TaskMstID, dbo.TaskMst.OnDate, dbo.TaskMst.DescriptionFROM dbo.MemberMst left JOINdbo.TaskMst ON dbo.MemberMst.MemberID = dbo.TaskMst.MemberID\[/code\]O/P:\[code\]MemberID fname TaskMstID OnDate Description3 Ursula NULL NULL NULL84 Opeyemi 30 2012-09-18 00:00:00.000 asd85 test 21 2012-09-18 10:30:46.900 aaa85 test 22 2012-09-18 10:31:04.967 eeee85 test 23 2012-09-18 10:31:26.640 vvvv\[/code\]Here in above query i get 3 Rows of MemberID=85 who posted 3 tasks but i need only one task from that member which is Latest. How to Get the Latest Task posted by a member so that result would be:-\[code\]MemberID fname TaskMstID OnDate Description3 Ursula NULL NULL NULL84 Opeyemi 30 2012-09-18 00:00:00.000 asd85 test 23 2012-09-18 10:31:26.640 vvvv\[/code\]I mean to say just only one record for each memberID having tasks?Help Appreciated..!Thanks in advance...!