SELECT t.LotNumber, t.Container, t.Lot_Pieces, t.Lot_Balance FROM MyTable t > WHERE t.LotNumber IN (SELECT top 3 sq.LotNumber, sq.Container, sq.Lot_Balance > FROM MyTable sq > WHERE sq.Container = t.Container ) >First, in VFP SELECT TOP n requires ORDER BY clause. Second, such subquery would generate an error.