sql.md

条件で絞り込んだテーブルとのright outer join & includes

class Bill
  def self.with_company(bill_month)
    joins(sanitize_sql_array(['right outer join companies on companies.id = bills.company_id and bills.bill_month = ?', bill_month])).select('bills.*, companies.id as company_id').includes(:user)
  end
end