select id,name,type from a union all select id,name,type from b union all select id,name,type from c
select * from ( select id,name,type,pubdate from a union all select id,name,type,pubdate from b union all select id,name,type,pubdate from c ) tem order by pubdate
pengdali(大力 V3.0) : "tem order by pubdate "是什么意思?好像执行错误。谢谢!
union all
select id,name,type from b
union all
select id,name,type from c
select id,name,type,pubdate from a
union all
select id,name,type,pubdate from b
union all
select id,name,type,pubdate from c
) tem order by pubdate
"是什么意思?好像执行错误。谢谢!
由于以前玩的都是对象数据库,最近要做一个基于sql server2000的项目,许多技术问题要向你请教。谢谢支持!