> ORDER BY waybill.waydate, waybill.waybill
>
> And it works ! I assume a muddle with pod.waybill or something.

Have you tried

ORDER BY 2, 1

Also, is there an index on (waydate, waybill) which I think
will help performance anyway.

I have seen similar problems when trying to get a secondary
sort in the right order, but never investigated farther.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services