具有重复的tel:select tel from (select tel from a union all select tel from b union all select tel from c union all select tel from d ) a group by tel having count(*)>1
用楼上的方法: select tel from ( select tel from a union all select tel from b union all select tel from c union all select tel from d ) a group by tel having count(*)>1
select tel from ( select tel from a union all select tel from b union all select tel from c union all select tel from d ) a group by tel having count(*)>1
(select tel from a
union all
select tel from b
union all
select tel from c
union all
select tel from d
) a group by tel having count(*)>1
select tel
from
( select tel from a
union all
select tel from b
union all
select tel from c
union all
select tel from d
) a
group by tel
having count(*)>1
from
( select tel from a
union all
select tel from b
union all
select tel from c
union all
select tel from d
) a
group by tel
having count(*)>1