Randall,

A faster way to do this:

select tableA.* ;
   from tableA ;
   into cursor missing ;
   where not exists ;
   ( select keyfield from tableB where tableB.keyfield = tableA.keyfield )

NOT IN requires much more work to be done by the SQL engine.

>I just thought about it. This does give me a table with everyrthing that is there but I still will have not idea of what's missing. For example, table A has 100,000 records in it. The result table gomes up with 95,000 matches. How do I know of the 5000 records in table A are missing in table B? I was thinking I could mark them some how. Then I would have a table of what was not in there. Maybe I could change the code to say NOT IN?