一个sql查询？

11 |

有两个表A,B，各一列
A：aa,bb,cc,dd,ee,ff
B：aa,cc,dd,gg.
写一个select 语句，查出两表中不同的列。
谢谢!

千问 | 2007-9-26 18:42:10 | 显示全部楼层

(select a from a
minus
select b from b)
union all
(select b from b
minus
select a from a)
;

千问 | 2007-9-26 18:42:10 | 显示全部楼层

select a from a where a.a not in (select * from b)
union
select b from b where b.b not in (select * from a);

千问 | 2007-9-26 18:42:10 | 显示全部楼层

各位多谢啦！

千问 | 2007-9-26 18:42:10 | 显示全部楼层

union,minus 都是啥意思?

主题	0 回帖	4882万积分

Rank: 8 Rank: 8

热门排行