I think what I meant was something more like "You can think of it as basically just the Cartesian Product of your two tables, and then filtering out rows based on how you specified the query." I'll make that change now.
I recognize that you would want to do the filtering first, of course, and only materialize the final table at the very end after everything else finishes.
Other than that, though, am I missing anything else? It's quite possible due to, as I said, how new I am to relational databases.