sql

Question

I'm doing some basic sql on a few tables I have, using a union(rightly or wrongly)

but I need remove the duplicates. Any ideas?

Answer 1

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;

Answer 2

The "union" operator does not create duplicates by itself.

You should use the keyword "all" for having duplicates.

Can you post your SQL query