It's always better to use the plural form when doing that, because it corresponds to the table name, when you use the singualr form, rails assigns an alias so in your example it becomes,

INNER JOIN roles role ON role.user_id = users.id

See what happened there? it became an alias of the actual table name. Hope this answers your main question.