Rails equivalent active record query for SQL query

Question

How can I write a rails4 active record equivalent query for the following MySQL query?

SELECT c.id,c.account_name,sum(i.balance) as balance from clients c, invoices i 
where c.id = i.client_id GROUP BY  c.id

Renaud Kern · Accepted Answer · 2015-11-04 14:04:14Z

1

Client.joins(:invoices).select('clients.id, clients.account_name, sum(invoices.balance) as balance').group('clients.id')

answered Nov 4, 2015 at 14:04

Renaud Kern

1,15610 silver badges25 bronze badges

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

3 Comments

Is it possible to write query with out join?

Client.joins(:invoices) is equivalent to from clients c, invoices i where c.id = i.client_id.

But you can also use the find_by_sql method:

Clients.find_by_sql "SELECT c.id,c.account_name,sum(i.balance) as balance from clients c, invoices i where c.id = i.client_id GROUP BY  c.id"

should work.