Path: utzoo!mnetor!uunet!lll-winken!lll-tis!ames!pasteur!ucbvax!agate!violet.berkeley.edu!steve
From: steve@violet.berkeley.edu (Steve Goldfield)
Newsgroups: comp.databases
Subject: Re: dBaseIII+
Message-ID: <8893@agate.BERKELEY.EDU>
Date: 18 Apr 88 21:25:02 GMT
References: <2413@mandrill.CWRU.Edu>
Sender: usenet@agate.BERKELEY.EDU
Reply-To: steve@violet.berkeley.edu.UUCP (Steve Goldfield)
Organization: University of California, Berkeley
Lines: 11
Keywords: dBaseIII+, Existential Quantifiers

In article <2413@mandrill.CWRU.Edu> ananth@mandrill.CWRU.Edu (ananth srinivasan) writes:
#>I have a problem with dBaseIII+ syntax and would appreciate any help.
#>I have two relations with join-able attributes (say ID) and I need
#>to find out those ID's that exist in one and don't exist in the other.
#>In SQL I can use the NOT EXISTS syntax; in QUEL I can use the
#>ANY...=0 syntax; and in Rbase V I can use the SUBTRACT operator
#>(which really makes the most sense). My question is what is the
#>appropriate syntax in dBase?

Unless you have a feature I don't know about with the plus,
all you can do in dBase is to index both files and then loop
through each doing a find on the other.