新手问题 怎么关联查询出两张表数据

Soyl · April 04, 2018 · Last by Soyl replied at April 07, 2018 · 1520 hits

我想两张表(logs,parameters)的数据查询出来,但是结果只打印出来一张表的数据

Log.joins(:parameter).where(article_id: params[:id])

生成的 SQL 语句为:

SELECT `logs`.* FROM `logs` INNER JOIN `parameters` ON `parameters`.`id` = `logs`.`parameter_id` WHERE `logs`.`article_id` = 208

但是我想查询 parameters 和 logs 表里的信息怎么做比如改成下面的 sql

SELECT * FROM `logs` INNER JOIN `parameters` ON `parameters`.`id` = `logs`.`parameter_id` WHERE `logs`.`article_id` = 208
You need to Sign in before reply, if you don't have an account, please Sign up first.