"Left Join" like table

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

You can most likely use a Query column for that.

1 Like