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:
Additional information is also found in the paper Implementation Techniques for Main Memory Databases.
