Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement