Posted by markc600 on 03/07/06 16:17

You should simply be able to UNION your
queries together. UNION will remove duplicates

SELECT [stock code],[stock desc]
FROM Tab1...
UNION
SELECT [stock code],[stock desc]
FROM Tab2...
UNION
SELECT [stock code],[stock desc]
FROM Tab3...

[Back to original message]