请教在存储过程里从四张表里查询数据

[wangtiantian23]

目前我有四张表，表结构一摸一样（具体历史原因不在深究了）。table1，table2，table3，table4
现在只想查出最四张表里的最后一条记录。

select * from table1 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1;

select * from table2 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1;

select * from table3 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1;

select * from table4 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1;

怎么样写个存储过程，把这四张表查询出来的结果显示在一张表里。

万望各位大神不吝赐教！！！

[wangtiantian23]

请问这个有可能吗？在线等~~

[rucypli]

select * from table1 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1 union all select * from table2 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1 union all select * from table3 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1 union all select * from table4 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1;

[wangtiantian23]

@rucypli 报错了！ [Err] 1221 - Incorrect usage of UNION and ORDER BY

[wangtiantian23]

@rucypli 非常感谢！搞好了！百度了一下，少了括号。 (select * from table1 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1) union all (select * from table2 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1) union all (select * from table3 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1) union all (select * from table4 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) order by id desc limit 0,1); 这样就好了！非常感谢！

[二月十六]

e.g.

SELECT * FROM (
SELECT * from table1 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) desc limit 0,1
union all
select * from table2 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) desc limit 0,1
union all
select * from table3 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) desc limit 0,1
union all
select * from table4 where DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= date(yuer_time) desc limit 0,1)t
order by id