Re: Using Joins

Article View: borland.public.vdbase.data.sql

Article #569

Back to borland.public.vdbase.data.sql Previous Next

#569

From: Michael Rotteck
Date: Sat, 10 Oct 1998 00:00

27 lines
1171 bytes

On Fri, 09 Oct 1998 19:12:26 -0400, Tom Arnold <tarnold@inna.net>
wrote:

Hi Tom,

when you create a join with ORDER BY the answer table is read-only.
You can create a temporary table of the join with SAVE TO and then
CREATE INDEX...

>Michael,
>I did a join with Order By on a field that was an index in one of the
>two tables joined.  I guess it must have been the join that screwed it
>up.
>-- 
>   Tom 
>   Bena, VA
>
>Michael Rotteck wrote:
>> On Thu, 08 Oct 1998 18:08:28 -0400, Tom Arnold <tarnold@inna.net>
>> wrote:
>> SQL ORDER BY do a sort.
>> 
>> When the field have an index ORDER BY use the index and FindKey()
>> works.

--
Michael Rotteck

Technical Details

Message-ID: <361f24af.143646945@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <361D37DC.79D6@inna.net> <361e077e.70639317@forums.borland.com> <361E985A.7F5@inna.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,a7ecc2e42a78f594
X-Google-Attributes: gidff5a1,public
From: 100277.441@compuserve.com (Michael Rotteck)
Subject: Re: Using Joins
Date: 1998/10/10
Message-ID: <361f24af.143646945@forums.borland.com>
X-Deja-AN: 399699034
References: <361D37DC.79D6@inna.net> <361e077e.70639317@forums.borland.com> <361E985A.7F5@inna.net>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message