ZS Associates Interview Question

tell me about join in SQL key concept so on..