如何查詢mysql的多个不同表
例如 表 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
[解决办法]
select * from aunion allselect * from border by date