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'.

Select *whatever_fields* FROM *whatever_tables* WHERE *whatever_condition* ORDER BY *total_field* DESC LIMIT 10

check THIS post

HTH

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.

Welcome to UA !