General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi,
I'm surprised that it doesn't complain about syntax here. It was always my understanding that order by was based on the result set, which has no need for use of an alias because there cannot be a field name conflict in the result set.
If simply "customer, date" doesn't work then try using the field numbers (1 being the first in the result set, 2 being second, etc).
Good luck,
Jim N
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only