search for: instructorprofil

...ctor_profile (may or may not exist) instructor_profile, field "sca_name" belongs_to :user I would like to craft a search on these fields, which is effectively this, but in one go: matching_users = User.where("mundane_name ILIKE ?", "%#{target}%") matching_profiles = InstructorProfile.where("sca_name ILIKE ?", "%#{target}%").map(&:user) (matching_users + matching_profiles).uniq However, I''m having problems formulating the query. Not all users have a profile, so some of the joins techniques would not work as they would only search a user if a...