>select transaction.*,customer.name ;
>From Transaction, Customer ;
>where transaction.customer = customer.code ;
>order by transaction.customer,transaction.date

From the looks of this statement, your result should be in ascending order by transaction.customer (or customer.code). Is this what you are seeing?