Re: ROWID / subselect problem

From: Mark <mark.harris.spam.begone_at_ukonline.co.uk.spam.begone>
Date: Fri, 31 Jan 2003 07:16:19 -0000
Message-ID: <3e3a22c3$0$2573$afc38c87@news.easynet.co.uk>

> Based on your statements your problem is that your database design, and I
use
> the word design in its loosest possible interpretation, is not normalized.
There
> is no excuse for duplicate rows anywhere at any time for any reason in any
> relational database. Clean up your data!
>
> In any case selecting MIN or MAX rowid with a GROUP BY will solve the
problem
> until you clean up the mess.
>
> And by all means clean up the mess. Otherwise this will haunt you for an
> eternity.

Thanks for the thoughts.

MIN/MAX solved it - thanks.
Can't clean up the data, unfortunately.

Mark Received on Fri Jan 31 2003 - 01:16:19 CST