Added JOIN and a bit of WHERE.

There's still work to be done on WHERE -- right now the IS NOT NULL part does
not save you a bit of typing. Also, I want to figure out a way to easily do
nested WHEREs.