Re: SQL and query designer (5.5)

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

Article #1404

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

#1404

From: Tim Smith
Date: Sun, 25 Jan 1998 00:00

29 lines
1395 bytes

On Tue, 20 Jan 1998 00:05:50 GMT, koterski@SPICEDHAM2borland.com
(Steve Koterski) wrote:

Hi Steve,

vdb insisted on regarding "DISTINCT" as a field, so I removed it,
reversed the table order and bingo! it worked. However I do not
understand how vdb created the join when there are no values in the
child table key field. Any chance of an explanation?

Thanks
>
>  SELECT DISTINCT *
>  FROM POP_ITEM PI
>    INNER JOIN PURCHASE_ORDER PO
>      ON (PI.ORDER_NUMBER = PO.ORDER_NUMBER);
>
>**************************************************************************
>Steve Koterski
>Borland International, Inc.
>http://www.borland.com/delphi
>(Remove the "SPICEDHAM2" from the address. Death to spam-bots!)

--
Tim Smith
If you can read this replace deleteme with Tim to reply

deleteme@dhscient.demon.co.uk

Technical Details

Message-ID: <34cbac57.14331576@news.demon.co.uk>

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

References: <34c3dafe.9355111@forums.borland.com> <34c3e924.27859321@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,bf04adadd27a4fa9
X-Google-Attributes: gidff5a1,public
From: Tim Smith
Subject: Re: SQL and query designer (5.5)
Date: 1998/01/25
Message-ID: <34cbac57.14331576@news.demon.co.uk>
X-Deja-AN: 319194560
Content-Transfer-Encoding: 7bit
References: <34c3dafe.9355111@forums.borland.com> <34c3e924.27859321@forums.borland.com>
MIME-Version: 1.0
X-NNTP-Posting-Host: dhscient.demon.co.uk [158.152.15.232]
Content-Type: text/plain; charset=us-ascii
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message