TCS interview question

What is Left Join In SQL?