Hello,
Could anyone be so kind to have a look at the following ...?
I have an Order and Customer table. Each Order is placed by a Customer. Customer can place more than 0 Orders. Order has CreateDateTime.
I want to get a set of 'most recent created' orders, but each order should have a unique customer.
So say ...
order 8, 16h00, customer 1
order 7, 15h00, customer 2
order 6, 14h00, customer 2
order 5, 15h45, customer 3
order 4, 15h40, customer 3
order 3, 15h35, customer 3
order 2, 15h30, customer 4
order 1, 15h25, customer 4
I would like to get an ordercollection with the orders no: 8, 7, 5 and 2
Thanx for any suggestion,
Paul