🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Intersect, Minus

#541
From: Steve Koterski
Date: Mon, 05 Oct 1998 00:00
20 lines
1601 bytes
On Mon, 05 Oct 1998 11:45:05 -0400, "David M. O'Neil"
<David@ONeilComputing.com> wrote:

>Does Visual Dbase7 support the SQL commands "Intersect," and "Minus?"

No. Local SQL (what the BDE uses for dBASE and Paradox tables) does not
include support for those two join operators. The BDE is the default data
engine for Visual dBASE (and other INPRISE programming tools), so no Visual
dBASE would not support an SQL statement that used either of those join
operators.

You can typically compose SQL statements that do the same thing using only
"basic" statements.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                 "What is success in this world? I would say
Technical Publications         it consists of four simple things: to live
INPRISE Corporation            a lot, to love a lot, to laugh a lot, and
http://www.inprise.com/delphi  from it all, to learn a lot."
                                                     -- Richard J. Needham
Technical Details
Message-ID: <361bfb68.5201418@forums.inprise.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <3618E981.28ACFAC7@ONeilComputing.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2c8c52f8201f48a5
X-Google-Attributes: gidff5a1,public
From: skoterski@NOSPAMinprise.com (Steve Koterski)
Subject: Re: Intersect, Minus
Date: 1998/10/05
Message-ID: <361bfb68.5201418@forums.inprise.com>
X-Deja-AN: 397964012
Content-Transfer-Encoding: 7bit
References: <3618E981.28ACFAC7@ONeilComputing.com>
Content-Type: text/plain; charset=us-ascii
Organization: INPRISE Corporation, Technical Publications
Mime-Version: 1.0
Reply-To: skoterski@NOSPAMinprise.com
Newsgroups: borland.public.vdbase.data.sql