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...

• Next in forum: beginner: "Login failed for user 'sa'."
• Prev in forum: How can I do amalgamate 3 select queries and then get unique entries from the result
• Thread view: Re: How can I do amalgamate 3 select queries and then get unique entries from the result

[Reply to this message]