Re: Select Distinct over Database Link

From: Gene Hubert <gwhubert_at_hotmail.com>
Date: 22 Aug 2002 05:48:57 -0700
Message-ID: <7e3fa619.0208220448.25a46902@posting.google.com>

TurkBear <jgreco1_at_mn.rr.com> wrote in message news:<ldh7mu8rucjmo9jfqbcio4ujc74hgaa7lc_at_4ax.com>...
> Just 1 additional try:
>
> Have you tried
>
> Insert into mylocaltable
> Select mykey from ( select distinct mykey from monster_at_mydblink );
>
>
> This should push the distinct to the remote server and just return the subset..
>

That's a clever thought but it doesn't do it. The remote db query is: select mykey from monster;

Gene Hubert Received on Thu Aug 22 2002 - 07:48:57 CDT