CME Group Interview Question

What are joins and explain about left join