Aug 5 2004, 10:26 AM
i have a table of invoices which are categorized by 'age' and by an 'owner'. i am trying to create a query which returns the top 10 invoices in both categories. i.e. top 10 invoices owned by 'mark' and 'less than 30 days' old. There are currently 20 'owners' and 8 invoice 'ages'.
Aug 5 2004, 10:42 AM
Select *whatever_fields* FROM *whatever_tables* WHERE *whatever_condition* ORDER BY *total_field* DESC LIMIT 10
Aug 5 2004, 10:44 AM
Aug 5 2004, 11:52 AM
thank you vey much for your help, i checked the other post and have been able to solve my problem. Such a simple idea, but they are always the best ones.
Aug 5 2004, 12:26 PM
Welcome to UA !
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here