Temporary Append?

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Hi,

I have two tables from different sources - and want to
compare them to test whether the same information is in
both (in theory it should be the same data, and the
purpose of the database is to check this).

Is it possible to "append" these tables temporarily in a
query and then check for duplicates (as opposed to making
an appended table)? Inner joins are no good, as I would
like to see the records underneath each other (as in an
appended table).

Thanks very much, all help appreciated.

Anna
 
have you tried using the query wizard to create
an "unmatched records" query? if the data in the two
tables is the same, the query should come up empty.
 
Hi,

Thanks for your reply. As part of the database I have
included "unmatched" queries, but I also want to see the
matched records - do you know of an easy way to do this?

Thanks,
Anna
 
Perhaps an union could work

select recId,recDiscription
FROM
SELECT UnmatchedQuery.Recid,'Unmatched'
From UnmatchedQuery
UNION
SELECT MatchedQuery.Recid,'Matched'
From MatchedQuery
Order by ....

the select from unmatched & matches should have the same
fieldnames & types in the same order
 
The union did the trick - thanks!

Cheers,
Anna
-----Original Message-----
Perhaps an union could work

select recId,recDiscription
FROM
SELECT UnmatchedQuery.Recid,'Unmatched'
From UnmatchedQuery
UNION
SELECT MatchedQuery.Recid,'Matched'
From MatchedQuery
Order by ....

the select from unmatched & matches should have the same
fieldnames & types in the same order

.
Click to expand...
 
Back
Top