working on join order. not finished. keeping the streak
join columns are no longer moved to the left . closes #802