Path: utzoo!mnetor!uunet!lll-winken!lll-tis!ames!pasteur!ucbvax!decwrl!decvax!mandrill!ananth From: ananth@mandrill.CWRU.Edu (ananth srinivasan) Newsgroups: comp.databases Subject: dBaseIII+ Message-ID: <2413@mandrill.CWRU.Edu> Date: 12 Apr 88 14:43:05 GMT Organization: CWRU Dept. of Computer Engineering, Cleveland OH Lines: 6 Keywords: dBaseIII+, Existential Quantifiers 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?