What is a common mistake with Join and GroupJoin in LINQ?

Joining on the wrong or non-indexed keys can create duplicates and expensive plans. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.