🚀 go-pugleaf

On Fri, 19 Feb 1999 19:14:51 -0800, Mark Berry <markb@nospam.mcbsys.com>
wrote:

[...]

>I have an application that is supposed to maintain a 1:1 relation
>between two tables, Contact1 and Contact2, based on the AccountNo
>field.  Sometimes this gets out of whack, and I'm trying to write a
>little VDB7 routine to display (and ultimately delete) orphaned
>records.  The example below looks for Contact1 records with no matching
>Contact2.  
>
>The basic question is how to identify orphaned records with SQL.  My
>RIGHT OUTER JOIN checking a field in the "left-side" table for NULL
>doesn't seem to bring back any rows.

[...]

What version of the BDE are you using? I seem to recall a problem in some
earlier version using outer joins *and* filtering to just the non-matching
rows like this. Does it work if you juxtapose the two tables and use a LEFT
OUTER JOIN?

//////////////////////////////////////////////////////////////////////////
Steve Koterski                       "For people who like peace and quiet:
Technical Publications               a phoneless cord."
INPRISE Corporation                                             -- Unknown
http://www.inprise.com/delphi