Table A (1,3,5,6,8,9)Table B (1,2,4,8,10,11)查出A、B表中独有的列来。
答案: select isnull(A.Id, B.Id) from A full join B on A.Id = B.Id where A.Id is null or B.Id is null
应该还有更好的答案.大家也试着做一下.
Novots Technologies Limited