我现在遇到的问题是，我要从两个不同的表中同时随机取出几条记录，然后把这些记录在放在一张表里显示，如
select top 5 * from stu1 order by newdid()     select top 5 * from stu2 order by newdid()这样写的话会出现两张表，我试过用select top 5 * from stu1 order by newid() uoion select top 5 * from stu2 order by newid()
但是提示错误，那位高手能告诉我一下，应该怎么把这两个连在一起？

感谢各位，问题应经解决，order by 和union可以在一起用
select * from(select top 5 * from table1 order by newid())A union
select * from (select top 5 * from table1 order by newid())B就可以了

感谢各位，问题应经解决，order by 和union可以在一起用
select * from(select top 5 * from table1 order by newid())A union
select * from (select top 5 * from table1 order by newid())B就可以了

感谢各位，问题应经解决，order by 和union可以在一起用
select * from(select top 5 * from table1 order by newid())A union
select * from (select top 5 * from table1 order by newid())B就可以了