Ruby on Rails ActiveRecord query using a join April 26, 2023 by Tarik In rails 4 you can make this even more clear: User.joins(:pets).where.not(pets: { name: 'fluffy' })