例如 表 a
Lname online date
火狐 good 2010-01-02
IE very good 2010-01-03
表 b
Cname os date
psp linux 2010-01-01
ps3 linux 2010-01-06我想两个不同的表一起排列怎么排??
1 2 3
psp linux 2010-01-01
火狐 good 2010-01-02
IE very good 2010-01-03
ps3 linux 2010-01-06
Lname online date
火狐 good 2010-01-02
IE very good 2010-01-03
表 b
Cname os date
psp linux 2010-01-01
ps3 linux 2010-01-06我想两个不同的表一起排列怎么排??
1 2 3
psp linux 2010-01-01
火狐 good 2010-01-02
IE very good 2010-01-03
ps3 linux 2010-01-06
union all
select * from b
order by date
SELECT Lname AS name,online AS os,date FROM a,b where a.date=b.date order by date