news id title addtime content 1 趋势中国研发中心 ... ... 2 .NET程序员 ... ...idea id title addtime content 1 发出回复 ... ... 2 重写 ... ...就这样很多表 把所有表的 title,content 查询出来 然后数据绑定
那union all为什么不可以呢?select title,content from news union all select title,content from idea--或者需要这样写?select title,content from ( select title,content from news union all select title,content from idea )t
select * from news union all select * from idea?
select title,content from news union all select title,content from idea union all ...
select title,content from news union all select title,content from idea union all ...
coolingpipe(冷箫轻笛 还在吗
id title addtime content
1 趋势中国研发中心 ... ...
2 .NET程序员 ... ...idea
id title addtime content
1 发出回复 ... ...
2 重写 ... ...就这样很多表 把所有表的 title,content 查询出来 然后数据绑定
union all
select title,content from idea--或者需要这样写?select title,content
from
(
select title,content from news
union all
select title,content from idea
)t
from news
union all
select title,content
from idea
union all
...
from news
union all
select title,content
from idea
union all
...