Hi,
I am trying to show a list of accounts where 2 identical products, have been ordered for the same account, within the same calendar month.
Field names:
A/c number,
Order id,
Cust name,
Product,
Purchase date
I have used GROUP BY and HAVING, but I am concerned with the volume of records returned.
Any help, please?
Thank you