Hi Enmanuel,

Try

* Get key fields for oldest members 
SELECT Family, Level, MAX(Age) AS Age ;
	FROM mytable ;
	GROUP BY 1,2 ;
	INTO CURSOR crsOldestKey NOFILTER

* Get all fields	
SELECT mt.Family, mt.Name, mt.Level, mt.Age ;	
	FROM mytable mt ;
		JOIN  crsOldestKey cok ON cok.Family = mt.Family ;
			AND cok.Level = mt.Level ;
			AND cok.Age = mt.Age

>Hi all, I have a table with the following fields: Family, name, age and level. In this table a family can have several members and I need a SQL statement that gets me the older member of each family order by level. For example:
>
>

>Family  Name      Age    Level
>--------------------------------
>01      xxxxxxxx   15      1
>01      xxxxxxxx   13      1
>01      xxxxxxxx   17      2
>02      xxxxxxxx   12      1
>02      xxxxxxxx   15      1
>02      xxxxxxxx   13      1
>03      xxxxxxxx   13      1
>03      xxxxxxxx   18      2
>03      xxxxxxxx   12      1
>
>

>
>The result should be:
>
>

>Family  Name      Age    Level
>--------------------------------
>01      xxxxxxxx   15      1
>02      xxxxxxxx   15      1
>03      xxxxxxxx   13      1
>01      xxxxxxxx   17      2
>03      xxxxxxxx   18      2
>
>

>
>Any help is greatly appreciated!
>
>