split newShallowJoinSql into core
done subSelect but with extra space