simple query

[abhaysk]

Select 
  A.* 
From
  (Select distinct acct_no, name From Transact) A,
  (Select distinct acct_no, name From Transact) B
Where
  A.acct_no = B.acct_no And
  A.name <> B.name
;

Abhay.