# Qualifying columns in where clause

**URL:** <https://discourse.rom-rb.org/t/qualifying-columns-in-where-clause/536>\
**Category:** Issues\
**Created:** [April 25, 2022, 4:42pm UTC](https://discourse.rom-rb.org/t/qualifying-columns-in-where-clause/536 "2022-04-25T16:42:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![synusynu](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/synusynu/32/262_2.png) [@synusynu](https://discourse.rom-rb.org/u/synusynu)\
**Post date:** [April 25, 2022, 4:42pm UTC](https://discourse.rom-rb.org/t/qualifying-columns-in-where-clause/536/1 "2022-04-25T16:42:51Z")

</div>

Hi,  
i have a quick question 🙂  
How can we qualify column in `where` clause?

I want to use columns from joined table in `where` clause, but i can’t get how it could be easily done  
The only thing i found after going through docs and forum is

```auto
users.join(:tasks).where(Sequel.lit('users.id = 1')).to_a

```

isn’t there something like

```auto
users.join(:tasks).where('users.id': 1).to_a

```

?  
I cannot get old notation `users__id` to work, i think it’s not supported anymore, am i right? 🙂

---

<div class="post-metadata">

**Author:** ![solnic](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/solnic/32/279_2.png) [@solnic](https://discourse.rom-rb.org/u/solnic)\
**Post date:** [April 27, 2022, 9:03am UTC](https://discourse.rom-rb.org/t/qualifying-columns-in-where-clause/536/2 "2022-04-27T09:03:59Z")

</div>

`users.join(:tasks).where(users[:id].is(1))` should work

---

<div class="post-metadata">

**Author:** ![synusynu](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/synusynu/32/262_2.png) [@synusynu](https://discourse.rom-rb.org/u/synusynu)\
**Post date:** [April 27, 2022, 11:06am UTC](https://discourse.rom-rb.org/t/qualifying-columns-in-where-clause/536/3 "2022-04-27T11:06:12Z")

</div>

ok, it does, thx 🙇‍♂️ 🙂