hi
i have two dbfs Transaction and customer
i did three different types of transactions

when i fire query with only transaction file i get all data in order i entered
( select * From Transaction order by customer, date)

but when i used both files
i.e.
select transaction.*,customer.name ;
From Transaction, Customer ;
where transaction.customer = customer.code ;
order by transaction.customer,transaction.date

it not giving in proper order it shows the last record i entered
in first position and first record in last position

all transaction r done on same date and customer
but of different types

because of this my report is not in proper order

TIA

vilas