Re: Avoid subquery

[Peter Brawley]

> I would like to avoid an expensive Subquery

Why assume all subqueries are expensive? In the FROM clause, for example, they're often quick:

SELECT a.father, a.name, a.age 
FROM child as a  
JOIN ( 
  SELECT father, max(age) AS oldest 
  FROM child
  GROUP BY father
) as b ON a.father = b.father and a.age = b.oldest;