>SELECT Member.FirstName,Member.LastName,Partner.LastUpdated FROM Member >JOIN Partner ON Member.Numero = Partner.NoMember AND Partner.Date>ldDate > AND Partner.LastUpdated = SELECT ( MAX(Partner.LastUpdated) FROM Partner > WHERE Member.Numero = Partner.NoMember AND Partner.Date>ldDate) >This is also an interesting approach. A few minutes ago, I used Cetin's approach.