sql - 表格之间的 Ruby 调节

Question

我有 2 个表:

反馈:faceid (as int), Poolid (as int), deleted (as boolean)

池:id(作为 int)，取消(作为 boolean)

除了某些行包含相同的值(pool.id 可以等于 feedback.poolid)之外，这两个表之间没有任何 DB 集成。

如果我在哪里用 SQL 编写我的查询，它会是这样的:

SELECT Pool.* , Feedback.* FROM Pool, Feedback WHERE faceid = params[:faceid] 
and deleted = 'f' and (Pool.id = Feedback.poolid and Pool.cancel = 'f') 

实现它的最佳(和参数化)方法是什么？

Answer 1

我认为以下将起作用:

 Pool.find_by_sql("select * from pools,feedbacks where pools.id = feedbacks.pool_id and cancelled = false and deleted = false and faceid = #{params[:faceid]}")