去除重复数据时用到了 union - -,求救! select distinct devicesbarcode from ( select checks.devicesbarcode,checks.checkday from cjCheck checks where checks.leftTimes ='QQDown' union select checks.devicesbarcode,checks.checkday from cjCheckers checks where checks.checkState ='LoadIng') tt