create table Clients ( iClKey i ) create table Orders ( iOdKey i, iOdClKey i ) select * ; from clients ; left join orders on iClKey = iOdClKey ; where isnull( iOdKey ) or iOdkey in ( select min( iOdKey ) from orders )will C5 VFP even with SP3 installed.