a表和b表都有同样的字段名 : address
如何将a表和b表的address 全部查出来,且不重复
select distinct address from ((select address from a) union (select address from b))
select address from a union select address from b --union默认就是去重的