# \#joins
**URL:** https://community.omni.co/tag/joins/9.md
[Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md)
---
## [How to join the same table twice](https://community.omni.co/t/how-to-join-the-same-table-twice/46)
**Author:** [@conor](https://community.omni.co/u/conor)\
**Replies:** 4\
**Last updated:** [November 19, 2025, 1:58am UTC](https://community.omni.co/t/how-to-join-the-same-table-twice/46 "2025-11-19T01:58:00Z")
When modeling topics, simplicity in naming conventions is key. Our goal to make the BI layer self-serve beings with prioritizing ease of navigation for our end users. Aliasing joins is a good start to build out tables …
---
## [Extended views for joining the same table with different logic](https://community.omni.co/t/extended-views-for-joining-the-same-table-with-different-logic/319)
**Author:** [@kylee](https://community.omni.co/u/kylee)\
**Replies:** 1\
**Last updated:** [September 10, 2025, 10:28pm UTC](https://community.omni.co/t/extended-views-for-joining-the-same-table-with-different-logic/319 "2025-09-10T22:28:53Z")
When building data models in Omni, there are times when you’ll want to join the same view more than once – like joining the users table twice, once as sellers and once as buyers. This is covered in a previous article, wh…
---
## [Translating Complex Looker Joins with COALESCE to Omni](https://community.omni.co/t/translating-complex-looker-joins-with-coalesce-to-omni/372)
**Author:** [@conor](https://community.omni.co/u/conor)\
**Replies:** 0\
**Last updated:** [July 31, 2025, 11:26am UTC](https://community.omni.co/t/translating-complex-looker-joins-with-coalesce-to-omni/372 "2025-07-31T11:26:24Z")
Translating Complex Looker Joins with COALESCE to Omni When migrating from Looker to Omni, one of the more challenging scenarios involves translating complex join patterns that use COALESCE in the join conditions. This a…