Use inner joins wherever possible in Views (basically, everywhere)

Basically the mirror issue to #1050594: Use inner joins wherever possible in Views (basically, everywhere). Seems like all these inner joins should be OK, though I'm a little tentative about the join to the node table.