Yes the unmatched query was based on 2 other queries. The 2 original queries
sorted the table data. There should have been several records in the left
query that did not match anything in the right query, based on the
information I was importing into my tables.
I'm not sure I quite understand it, but what I found was that I was losing
my records when I imported them into my tables. My 2 original tables are
used for several other things. When I set up a new table to bring in the
data, a table that is currently not being used for anything else, the records
come in fine. The ones I am trying to find in the unmatched query are in the
table. I run the unmatched query and it shows exactly what it should.
I'm assuming that the import is somehow smart enough to know that later in
the process those records would be invalid, so it does not allow them to be
imported. Is this true?