Thomson Reuters interview question

Explain SQL Join. What causes memory leaks in C#