Implement outer/inner/right join logic when joining on a key

[wesm]

Currently only left join is implemented. This will make the join-on more consistent with its SQL counterparts

[wesm]

Inner join also now implemented. Need to broadly address SQL-style joins, there are several other issues