--将2个sql语句结果合并,筛选重复的记录 select name from ( select * from test1 where ...... union select * from test1 )