LTIMindtree Interview Question

Explain joins and inner joins