假如有表t1,t2,t3,三个表结构完全相同,怎样能够一次取出这三个表里面的内容?用存储过程写的话?
3条回答 默认 最新
- threenewbee 2016-10-31 10:15关注
(select * from t1) union (select * from t2) union (select * from t3)
解决 无用评论 打赏 举报
假如有表t1,t2,t3,三个表结构完全相同,怎样能够一次取出这三个表里面的内容?用存储过程写的话?
(select * from t1) union (select * from t2) union (select * from t3)