> > @Anthony > > Though I believe it joins tables by using the WHERE clause (as opposed to > > JOIN, which is used when you pass the "join" or "left" argument to one of > > Set's methods). > > When SQL does that, it itself is doing an implicit JOIN. It's really > just a syntax convenience. The JOIN is logically there in the SQL, > just unstated. > Of course. You said it "superficially resembles a WHERE clause". I was just saying it actually _is_ a WHERE clause, albeit one that implements a join. This is explained here: http://web2py.com/book/default/chapter/06#Inner-Joins.
Anthony
