[thelist] MySQL question

[Erik Heerlein]

I have two tables each with a column called 'email'. I would like to 
gather up all of the distinct emails from both tables, no duplicates.

I have tried:

SELECT DISTINCT table1.email, table2.email
FROM table1, table2

but that just gives me two separate columns. I know I've done this 
before but I can't remember how to do it. Thank you for your time.


[>] Erik Heerlein