Temporary Append?

A

Anna

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

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top