create table temp
(
lorder int,
n nvarchar(10)
)insert into temp select lorder,n from A0,A1
insert into temp select lorder,n from A1select * from temp order by n
有点麻烦,想出好的在发给你
(
lorder int,
n nvarchar(10)
)insert into temp select lorder,n from A0,A1
insert into temp select lorder,n from A1select * from temp order by n
有点麻烦,想出好的在发给你
在SQL2005中table的名字不能用#开头