Qualifying columns in where clause

i have a quick question :slight_smile:
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

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

isn’t there something like

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? :slight_smile:

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

1 Like

ok, it does, thx :bowing_man: :slight_smile:

1 Like