有两张表A、B,都有一列名称为years,我想用distinct查询出A.years 和 B.years 中不重复的唯一的值,怎么做?谢谢啊
------解决方案--------------------
- SQL code
SELECT years FROM (SELECT years FROM AUNION ALL SELECT years FROM B) CGROUO BY years HAVING COUNT(years)=1
------解决方案--------------------
SELECT years FROM (SELECT years FROM AUNION ALL SELECT years FROM B) CGROUO BY years HAVING COUNT(years)=1
------解决方案--------------------