Maybank Interview Question

Basiq SQL question - what are Left Join and Right joint function? Etc