im confused....i just thot this will hit this...

ACCT_NO NAME
------- ----------
1001 SCOTT
1001 SCOTT

and not this one...

ACCT_NO NAME
------- ----------
1002 STEVE
1002 TOM