I am new to this, so please be patient...
- I have a table "tFruit".
- The fields inside tFruit are "ID", "Buyer", "Seller", "Time", and "FruitName".
- "ID" is the key field, the other 4 fiends has non-unique data.
When I use this SQL statement I will get all sellers sorted by Time. But an individual seller appears multiple times because they sold fruits not only once.
SELECT Seller FROM tFruit WHERE Buyer = 'firstname.lastname@example.org' ORDER BY Time DESC
What I want is to get the list of seller, non-duplicate, sorted by Time. Thus I use this statement:
SELECT Seller FROM tFruit WHERE Buyer = 'email@example.com' GROUP BY Seller ORDER BY Time DESC
Now there is no duplicate Seller, but they are not sorted by Time.
Any ideas how to do this?