column ordering with select * and mixed ansi / non-ansi joins is not expected

Generally it is expected that columns appear in their ordinal order corresponding to their appearance order in the from clause. The current behavior has the from clause ordering reversed.