How does an INNER JOIN behave in ActiveRecord, and what surprises does it cause (missing rows, duplicates, counts)?

Topic: rails, ActiveRecord and SQL. Level: Intermediate.

The full answer to this question is available to Interview Reader members. See what is free and what Premium adds.