To add another update here: left, right and outer joins have been added.