Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - Order By - Use multiple fields?
Message
From
13/09/1999 12:18:08
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL - Order By - Use multiple fields?
Miscellaneous
Thread ID:
00264042
Message ID:
00264042
Views:
56
In using a SELECT statement to store a variety of field information in a cursor, can I have an ORDER BY statement like this...

ORDER BY client.name,code.codetype,log.logdate

so that the resulting records are first sorted by the clients name, then under that name, the type of code and finally the date.
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Next
Reply
Map
View

Click here to load this message in the networking platform