>>Select * from basisverzekering ; >> left outer join wiskunde on basisverzekering.mijbrpls = wiskunde.mijbrpls ; >> AND wiskunde.vlgnr_mut = ( SELECT MIN(vlgnr_mut) FROM wiskunde w2 ; >> WHERE w2.mijbrpls = wiskunde.mijbrpls) > > > >>>Thanks that seems to work