哇，union的优先级很高嘛
原来，union的优先级很高。比如select stdname,[subject]='化学',化学 as score from #student2 union all select stdname,[subject]='数学',数学 as score from #student2 union all select stdname,[subject]='物理',物理 as score
