Account.find :all, :from => "visits LEFT JOIN accounts ON visits.account=accounts.id"And the following SQL query will result:SELECT * FROM visits LEFT JOIN accounts ON visits.account=accounts.id