While this article was not what I needed it does open the idea of Joins and the SQL engine behind the scene.