Query for creating join in rails

Question

I have two tables A(:id, :random) and B(:id, :flag). I need to do an inner join of A with B on :id and output only those records whose B.flag is true. I wrote a query like this :

A.joins(b).where(:flag => 'true')

But this translates to A.flag whereas I need B.flag

What should be the correct query?

Marek Lipka · Accepted Answer · 2015-03-26 10:06:14Z

2

You should explicitly point specific table:

A.joins(b).where(b_table_name: { flag: true })

answered Mar 26, 2015 at 10:06

Marek Lipka

51.3k7 gold badges90 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query for creating join in rails

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related