> Have STAFF_ID 27 selected while ordered by STAFF_ID -
> SURNAME = Wilson, change ordering to SURNAME and all
> I can see is the records from Wilson on.
>
> I am sure this was working OK so I must have changed
> something ? what.

What does the SQL Monitor show? Specifically looking for anything
that may be restricting the selection of records.


Geoff Worboys
Telesis Computing