select * from (
select ID,NAME from info_a
union
select ID,NAME from info_b
union
select ID,NAME from info_c
) as a order by ID desc
不知道可行不可行,没有测
select ID,NAME from info_a
union
select ID,NAME from info_b
union
select ID,NAME from info_c
) as a order by ID desc
不知道可行不可行,没有测
但是,我是说在mysql 4.0.x 下实现哦
扫墓回来牙齿又断了...去补牙了...To XqYuan:
4.0.x 支持union的...但是不支持子查询...非常感谢您的答复.:)