Check the condition in the query. I think count(*) is giving currect results.


------------
Jon at 3/14/01 1:58:50 PM

I have run a NOT EXISTS query comparing a table in test and production, to determine which records have been added to the table in production so I can import those records to test. The count(*) from both tables has a difference of 766 records but the query is showing 768. I am trying to find the easiest/quickest way to identify the orphan records.