General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sql Order by Problem
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
Next
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