# \#coalesce

**URL:** https://community.omni.co/tag/coalesce/32.md

[Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md)

---

## [Translating Complex Looker Joins with COALESCE to Omni](https://community.omni.co/t/translating-complex-looker-joins-with-coalesce-to-omni/372)

<div class="topic-metadata">

**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")

</div>

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…