Reported in a candidate post, Nov 2018
LEFT JOIN vs RIGHT JOIN and what joins are
Filed under Standard Chartered
The question
The candidate was asked what SQL joins are and the difference between left and right joins.
No write-up yet. Related questions below have one.
Related Standard Chartered questions
Collected from public candidate posts and coding forums. Updated Nov 2026.