Message-Id: <10572.113217@fatcity.com> From: "Christine Turner" Date: Fri, 28 Jul 2000 05:08:50 -0700 Subject: Comments on Why??? Good Morning All.... Working on something someone else wrote and maybe I'm missing the obvious. But would anyone have any idea as to why someone would use the rowid in this query???? insert into temp_big_gllist (glacct, desct) select distinct (gl_acct_no), (description) from gene310 t1 where t1.rowid = (select min(t2.rowid) from gene310 t2 where t1.gl_acct_no = t2.gl_acct_no); I'm having a hard time understanding why someone would do this and of course there are no notes left behind to explain. Anyone else have any ideas???? Thanks In Advance!! Take Care, Christine Turner DBA IPS SENDERO Scottsdale, Arizona