CRISIL interview question

Inner Join, Left Join, Basic Aptitude question