Article View: borland.public.vdbase.data.sql
Article #565Re: Using Joins
From: Tom Arnold
Date: Fri, 09 Oct 1998 00:00
Date: Fri, 09 Oct 1998 00:00
15 lines
930 bytes
930 bytes
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.
Technical Details
Message-ID:
<361E985A.7F5@inna.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<361D37DC.79D6@inna.net> <361e077e.70639317@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,a7ecc2e42a78f594 X-Google-Attributes: gidff5a1,public From: Tom Arnold <tarnold@inna.net> Subject: Re: Using Joins Date: 1998/10/09 Message-ID: <361E985A.7F5@inna.net> X-Deja-AN: 399516706 Content-Transfer-Encoding: 7bit References: <361D37DC.79D6@inna.net> <361e077e.70639317@forums.borland.com> Content-Type: text/plain; charset=us-ascii Organization: Microaid Mime-Version: 1.0 Reply-To: tarnold@inna.net Newsgroups: borland.public.vdbase.data.sql