THIQAH interview question

Difference between right and left SQL join