Good morning,
I have a data structure like that:
Subscriptions: users, addresses and so on, subscription data (each level of subscription give access to different gifts)
Shippings: planned shippings of these gifts, when are these shipping scheduled, which is the associated subscription, which gifts they include and so on.
I want to “left join” these two tables to know at a glance how many packages I have to prepare and where to ship them dowloading a CSV. I need to add a condition in that join “where customer status is active”
Is possible doing that?
Thanks for helping out