select c_title,c_content,c_date from t_news
union all
select c_3title,c_content,c_date from t_office
union all
select newsname,newscontent,adddate from shop_news
select * from
(select * from t_news(表1)
union
select * from t_office(表2)
union
select * from shop_news(表3)) a
------------------------------
where 條件.... " 這句是加查詢條件的可省不做
如果字段类型一样可以
select c_title,c_content,c_date from t_news
union all
select c_3title,c_content,c_date from t_office
union all
select newsname,newscontent,adddate from shop_news