>

>SELECT Child.date, Child.Amount, Child.OtherField,;
>       Parent.Name, Parent.Address,Child.ParentId;
>FROM mydbc.Child AChild;
>LEFT JOIN mydbc.Parent ON AChild.ParentId = Parent.Parentid ;
>WHERE Child.date IN (SELECT MAX(Child.date) FROM Child BChild WHERE BChild.ParentId == AChild.ParentId));
>GROUP BY AChild.ParentId
>

>(not tested)

Four stars if I could give them, thank you Borislav. This is the second time that reusing a tale with another alias has solved my problem, going to have to try and remember and reuse that trick.