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;