select a.*
from businaccount a, customer c,custperson cust
where a.client_id IN (SELECT b.client_id
FROM businaccount b
GROUP BY b.client_id
HAVING COUNT(*) > 1)
and a.client_id = c.client_id
and c.client_id = cust.client_id
order by a.client_id asc;