Select most recent product purchase for each customer

[machumpion]

Let's say I have an Orders table (fields: customerID, productID, Date, revenue).
Customers can have purchased multiple different products throughout time. How can I query what the most recent product each customer purchased is?

THank you!

I also have a products table and customer table with details but I don't think it's relevant to this query.

 

[KenHigg]

Group by cust id and max() the date?

 

[machumpion]

Group by cust id and max() the date?

I believe that worked , thanks!

 

[KenHigg]

Cool - Glad you have it working