Post reply

Select / Group by query

  • October 5, 2006 at 8:40 pm

    #664501

    SELECT T.id, T.dateModified, T.clientId, T.Comments

    FROM [tblTemp] T

    INNER JOIN (select Max(DateModified) as LatestDateModified, clientId

      from [tblTemp]

      group by clientId) DT ON T.clientId = DT.clientId AND T.dateModified = DT.LatestDateModified

     

    _____________
    Code for TallyGenerator

  • October 5, 2006 at 8:54 pm

    #664502

    Thanks Sergiy

    That works really well.  Appreciate the help and time.

    Regards, Alison

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply