Freshman
Registered User.
- Local time
- Tomorrow, 01:47
- Joined
- May 21, 2010
- Messages
- 437
Hi all,
I have 2 tables with a one to many relationship displaying orders for each Client.
If I run a query on all orders by Client, I get multiple lines for each Client which is to be expected but I need only one line per Client displaying only the most recent order by date. Not displaying any older orders.
I played around with the sum and 'orderby' min date but not getting a single line per Client.
Can anyone assist please?
Thanks
I have 2 tables with a one to many relationship displaying orders for each Client.
If I run a query on all orders by Client, I get multiple lines for each Client which is to be expected but I need only one line per Client displaying only the most recent order by date. Not displaying any older orders.
I played around with the sum and 'orderby' min date but not getting a single line per Client.
Can anyone assist please?
Thanks