28,405
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
opolmzy 2003-10-09
- 打赏
- 举报
（select * from biao） union (select * from baio2)
如果想保留所有重复，必须用union all代替union
（select * from biao） union all (select * from baio2)
如果想保留所有重复，必须用union all代替union
（select * from biao） union all (select * from baio2)
zhanghao5188 2003-10-08
- 打赏
- 举报
合并union
select * from biao union (select * from baio2)
select * from biao union (select * from baio2)
Tal 2003-10-07
- 打赏
- 举报
数据库是什么
select a.* from (select * from atable where id is not null) a,btable b where a.id=b.id
select a.* from (select * from atable where id is not null) a,btable b where a.id=b.id
junsunchen 2003-10-07
- 打赏
- 举报
union
sunnylake 2003-10-07
- 打赏
- 举报
union
007james 2003-10-07
- 打赏
- 举报
合并union
zlydaaa 2003-10-07
- 打赏
- 举报
union
