https://www.youtube.com/watch?v=yW-Re4TJcJ0

If you want to learn more about the different join algorithms, consult Wikipedia for an introduction to the basic material and links to additional information:

• Nested Loop Join
• Merge Join
• Hash Join

Additional information is also found in the paper Implementation Techniques for Main Memory Databases.