Phil Turmel wrote: > Richard/Joshua: > > MySQL has an example for this problem that addresses pre-4.1 and current > syntax (just max instead of min, adjust to suit): > > http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html Thanks - I'll give that a go. Particluarly evil for such a seemingly simple thing, but hey that's the way with a lot of these things. Cheers. -- R.Livsey www.livsey.org