# "Left Join" like table

**URL:** <https://community.glideapps.com/t/left-join-like-table/63528>\
**Category:** Ask for Help\
**Created:** [July 5, 2023, 4:21pm UTC](https://community.glideapps.com/t/left-join-like-table/63528 "2023-07-05T16:21:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pietro\_Castellani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pietro_castellani/32/59938_2.png) [@Pietro\_Castellani](https://community.glideapps.com/u/Pietro_Castellani)\
**Post date:** [July 5, 2023, 4:21pm UTC](https://community.glideapps.com/t/left-join-like-table/63528/1 "2023-07-05T16:21:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 5, 2023, 4:30pm UTC](https://community.glideapps.com/t/left-join-like-table/63528/2 "2023-07-05T16:30:12Z")

</div>

You can most likely use a Query column for that.

> **[Glide • Query Column](https://www.glideapps.com/docs/reference/computed-columns/query-column)**
>
> Create complex relations in your data with conditional filtering, sorting and limits.