At 02:35 PM 21/06/2006, Adam wrote:

>Select * From SalesOrder
>Join Customer on C.CustomerCode = S.CustomerCode
>order by customername
>
>That gives the optimiser more choice.

I guess Adam meant:

Select S.* From SalesOrder S
Join Customer C on C.CustomerCode = S.CustomerCode
order by C.customername

./heLen