Emulate outer joins

Review by @cvogt