Reported in a candidate post, Sep 2024
SQL joins, keys and three easy join queries
Filed under EY
The question
Asked what joins are, primary vs foreign keys, inner vs outer join and left vs right join, then three easy queries involving joins.
No write-up yet. Related questions below have one.
Related EY questions
Collected from public candidate posts and coding forums. Updated Nov 2026.