Select a.*, (Select Max(b.Bestelldatum) From Tab1 b where a.ETNummer = b.ETNummer) Bestelldatum From Tab1 a