I have a database full of products which were ordered via our website. What i would like to do is run an SQL query which would show the top 10 products ordered between a given date range.
There is 2 sets of fields which need to match to determine they are the same.
RetailCode must = SupplierCode
RetailDescription must = SupplierDescription
I would like to show the user running the query the number of times it has been ordered.
If i have not explained myself very well please feel free to ask any questions which will assist you in providing a solution.
Thank you in advance.