CODEWITHSUNDEEP
sqlruby-on-rails-3activerecord
mfq
mfq

Reputation: 1377

Rails active record conversion of this sql

SELECT players.name, batsmen.* FROM batsmen INNER JOIN players ON players.id = batsmen.player_id WHERE league_id = 13

How will I do this? I am using Rails framework and MySQL. Thanks in advance.

Upvotes: 3

Views: 81

Answers (1)

megas
megas

Reputation: 21791

Try this:

Player.joins(:batsmen).select('players.name, batsmen.*').where('batsmen.league_id = ?', 13)

Upvotes: 3

Related Questions