Mr. Cooper Interview Question

How left join is performed in RDBMS?