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

.
 
Top