fix joins, union and aliases plus 41 tests passing