Re: query help

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 26 Jul 2004 06:46:37 -0700
Message-ID: <1090849627.366950@yasure>

Mladen Gogala wrote:

> On Mon, 26 Jul 2004 00:43:07 +0000, Ana C. Dent wrote:
>
>

>>Not the way you are trying to solve this.
>>
>>Try matching ROWIDs between the main query & the sub-query.

>
>
> ROWID shouldn't be used if there is a primary key. ROWID is
> synthetic primary key, and if there is a real thing, no need
> for messing with a ROWID stuff. I provided a solution which
> does ensure uniqueness, without any rowids.

Except to avoid an index lookup of the rowid.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Jul 26 2004 - 08:46:37 CDT