Re: Using Joins

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

Article #566

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

#566

From: Tom Arnold
Date: Fri, 09 Oct 1998 00:00

12 lines
960 bytes

Bowen,
One of the two tables in was indexed on the field used in the Order By. 
The join respected the Order By, but I suppose that could have had
nothing to do with that tab.  All Ah knows is it don't work.  Just
thought I'd ask.
-- 
   Tom 
   Bena, VA

Bowen Moursund (TeamB) wrote:
> Seems logical to me that it wouldn't. FindKey() uses an explicitly named
> index. A join is a temp/virtual table that has no indexes.

Technical Details

Message-ID: <361E99F4.47F3@inna.net>

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

References: <361D37DC.79D6@inna.net> <6vlebo$1nc18@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: <361E99F4.47F3@inna.net>
X-Deja-AN: 399521200
Content-Transfer-Encoding: 7bit
References: <361D37DC.79D6@inna.net> <6vlebo$1nc18@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

Reply to Parent Message