Equinox Gold interview question

Explain left join? Explain inner query?