Hi Kuya,

I have a TRANSACT table with the following info:

ACCT_NO NAME
------- ----------
1001 SCOTT
1001 SCOTT
1002 STEVE
1002 TOM

I want to list(select) the acct_no being used by more than 1 person,
in this case its (1002).

Can u help me pls...
Sorry my mind does not work well these days...anyway im still trying.

Thanks a lot