slect * from table1 where id='1' union all select* from table2 where id='2',这只是一个例子,现在输入结果了,我要把这些结果取出前10条,要用到top语句,怎么写?select top 10 * from(slect * from table1 where id='1' union all select* from table2 where id='2')就出错了,我数据库学的不好,求教。。。