help~~~~~~~~~
heeh 2001-11-28 04:13:15 select top 1 'a' as I ,C,min(D) as D from test where I='a' and D is not null group by C order by D
union all
select top 1 'b' as I ,C,min(D)as D from test where I='b' and D is not null group by C order by D
error:
服务器: 消息 156,级别 15,状态 1,行 2
在关键字 'union' 附近有语法错误。
为什么不能union ,向高手请教