A
Anna
The union did the trick - thanks!
Cheers,
Anna
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
.