# \[feature request\] chained column joins

**URL:** https://forum.datomic.com/t/feature-request-chained-column-joins/2133
**Category:** Datomic Cloud
**Created:** [September 17, 2022, 11:43am UTC](https://forum.datomic.com/t/feature-request-chained-column-joins/2133 "2022-09-17T11:43:21Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![hden](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.datomic.com/hden/32/388_2.png) [@hden](https://forum.datomic.com/u/hden)
#### Post date: [September 17, 2022, 11:43am UTC](https://forum.datomic.com/t/feature-request-chained-column-joins/2133/1 "2022-09-17T11:43:21Z")

</div>

[Column joins](https://docs.datomic.com/cloud/analytics/analytics-concepts.html#column-joins) give us efficient ‘wide’ views but it’s limited to 1 hop. For analytical datasets we often need join multiple tables into an ‘ultra-wide’ view.

Let’s say we have a _country_ table, a _region_ table, an _availability-zone_ table, and a _instance_ table. We might be able to drastically improve query performance by joining all the tables in the metaschema instead of normal SQL JOINS.

 ![Screen Shot 2022-09-17 at 21.18.36](https://us1.discourse-cdn.com/flex016/uploads/cognitect/original/1X/5b0d22ebd1a7270c79ac36debc1cc4d4c71f3d4a.png)