>Thanks for the fast reply! Unfortunately, Foxpro returns with "Queries of this type are not supported" :-(

This should work

SELECT pt.*, ct.b_Name ;
	FROM ParentTable pt ;
	JOIN ChildTable ct ON pt.a_pk = ct.b_afk ;
		WHERE b_area = (SELECT MAX(b_area) FROM ChildTable WHERE b_afk = ct.b_afk)