Program:  Superbase
         Version:  1.3
         Topic:    Identifying records in a master file that do not have
                   matches records in a transaction file.
         Date:     August 18, 1992

         Summary:  Identifying records in a master file that does not
         have corresponding records in the transaction file is a two step
         process.  The first step is to  build a query with an outer join
         that produces a third file.  The second step is to remove the
         records that have matches in the tranaction file from the new
         file.


         Build a query
         1. Set the query optimizer on by choosing Command from the DML
            menu, then type SET QUERY ON.

         2. Choose Query form the Process menu to build a query.
            Include the key field from the master file and the
            corresponding key field in the transaction file in the
            Fields section of the query.  For example,

            Fields     MIDNUM.MASTER, TIDNUM.TRANS

         3. Create an outer join between the key fields.

            Filter     MIDNUM.MASTER *= TIDNUM.TRANS

         4. Send the results of the query to a Superbase file by choosing
            SB File.


         Remove unqualified records
         The result of the query includes records that have a match in
         the transaction file and records that do not.  The records that
         do not have a match in the transaction file have a zero in the
         TIDNUMID field in the new file.  Removing the records with the
         same value in the MNUMID and TNUMID fields results in a file
         containing the records that do not have a corresponding record
         in the transaction file.