Re: query help

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 26 Jul 2004 01:57:05 -0400
Message-ID: <pan.2004.07.26.05.57.05.225213@sbcglobal.net>

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.

-- 
A city is a large community where people are lonesome together.

Received on Mon Jul 26 2004 - 00:57:05 CDT