Join tables when the use case genuinely needs facts that live in different normalized relationships. Interviewers watch whether you can explain the relational reason behind the join rather than memorizing syntax alone.
The strongest answers connect the feature to reasoning and tradeoffs instead of reciting syntax.