At 07:51 PM 5/24/2003 +1000, you wrote:

>but the subselect needs to be a singleton anyway doesn't it? what's the use
>of an order by clause?

Because I need to control WHICH record becomes the "First 1".

-Joe