select HouseHold, padr(alltrim(Parent.fName) + iif(IsNull(Child.fName),"",", " + Child.fName),40) as Inhabitans, ... from myTable Parent left join myTable Child on Parent.HouseHold = Child.HouseHold and Parent.PK <> Child.PK where Parent.Age = (select max(Age) as Age from myTable X where X.HouseHold = Parent.HouseHold)That's just an idea, not tested.
>r# household Parent house# ages >1 Smiths Robert 27 42 >2 Bobby 27 4 && child of Robert >3 Barnes Mary 74 32 >4 Margy 74 2 && child of Mary >etc. >>
>r# household inhabitants house# ages >1 Smiths Robert, Bobby 27 42,4 >2 Barnes Mary, Margy 74 32,2 >etc. >>
>r# household Parent house# ages >1 Smiths Robert 27 42 >2 Smiths Bobby 27 4 && child of Robert >3 Barnes Mary 74 32 >4 Barnes Margy 74 2 && child of Mary >etc. >>