Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!asuvax!mcdphx!hrc!dan
From: dan@hrc.UUCP (Dan Troxel)
Newsgroups: comp.databases
Subject: a question regarding a query using Unify 4.0 SQL
Message-ID: <201603@hrc.UUCP>
Date: 14 Aug 90 19:04:55 GMT
Organization: Handwriting Research Corp. - Phoenix, AZ
Lines: 20


I am using Unify 4.0 with sql on a Convergent Tech. S/640.

I have 2 tables.

I wish to find all records in the parent table,
that are *not* found in its child table.

I believe this is wrong, at least *very* slow, but tell me what I have to do 
to fix it.

	select rolodex.entry_num from rolodex
		where rolodex.referral_source = 'POST*'
		and rolodex.entry_num ^=
		select rolnotes.rol_linker from rolnotes
			where rolnotes.rol_linker = rolodex.entry_num/
-- 
Dan Troxel @ Handwriting Research Corporation                  WK 1-602-957-8870
Camelback Corporate Center  2821 E. Camelback Road  Suite 600  Phoenix, AZ 85016
ncar!noao!asuvax!hrc!dan          zardoz!hrc!dan      hrc!dan@asuvax.eas.asu.edu