[RESOLVED] distinct values with JOIN, use DISTINCT?

[anakadote]

ok, so i have two tables, each with an email column. what i want to do is select all the emails from both tables without any duplicates.

by the way, im using mysql.

thanks much

[Lars_Berg]

select email from <tableone>
union
select email from <tabletwo>

[anakadote]

wow, thanks. that's a great function.