< snip >>
>Hi
>I'm afraid it will become too complcated and slow-running query but you caould try somethink like this:
>

 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.