Iris Software Interview Question

Sql join queries how will you define it