Emphasys Software Interview Question

Explain me about the joins