0

sql

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?

9th Feb 2017, 10:24 AM
Sunita Sharma
2 Antworten
0
SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2;
9th Feb 2017, 11:42 AM
Andreas
Andreas - avatar
0
The "union" operator does not create duplicates by itself. You should use the keyword "all" for having duplicates. Can you post your SQL query
9th Feb 2017, 11:45 AM
Rossano Praderi
Rossano Praderi - avatar