作者pakker (找寻蔚蓝天空)
看板Database
标题Re: [SQL ] 请问从五个资料表内抓最新的五笔SQL怎麽下
时间Thu Nov 1 22:01:47 2007
select * from (
(select * from board1 order by posttime limit 5) union
(select * from board2 order by posttime limit 5) union
(select * from board3 order by posttime limit 5) union
(select * from board4 order by posttime limit 5) union
(select * from board5 order by posttime limit 5) union
) AS U order by posttime limit 5;
这样?
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.121.23.85
※ 编辑: pakker 来自: 59.121.23.85 (11/01 22:21)