Hi,
I have a problem trying to count the total number of subscribed customers per order date. (i.e on the specified date, how many total subscribed customers are there, irrespective of whether they have placed an order that day or not). My key problem is trying to show customers on the order date that haven't ordered that day
The key details of my 2 tables are:
Subscriptions:
-Email Address
-Subscription Order Number (i.e the order number of the paid subscription package)
-Sub Start Date
-Sub End Date
Orders:
-Email Address
-Order Number
-Order Date
I have tried a few different methods, but just don't know the best way to do it so all help would be much appreciated. This is my first time posting so I apologise if I post this in the wrong place.
Thanks
MB
