select *
from person
where id in
(
select id
from person_main
group by id
having (count(*) > 1)
)
select *
from person
where id in
(
select id
from person_main
group by id
having (count(*) > 1)
)