deejay - 1:28 am on Oct 6, 2010 (gmt 0)
now that is interesting johnblack. I have to admit, whenever I have to use a subquery my biggest hurdle is deciding just where in the darn top query it goes (select, join, where, etc).
I think top 1 is sql syntax, rather than mysql, but it does raise the option of using limit in the subquery, which might just be what I'm looking for.
I'll go have a play and report back. -thanks.