Select fields accros multiple dbs..

[M2E]

Hi there - Happy New Year!!

I am trying to use the SELECT DISTINCT statement to create one list of email address I have which are in two different databases, I have tried the below syntax, but does not seem to work...can anyone please tell me where I am going wrong!!!

Thanks in advance....

SELECT DISTINCT m2e_db.email, events_bookings.email FROM m2e_db, events_bookings

----Ment2Excel (M2E)----
--LEARN BY EXAMPLE--

 

[guelphdad]

select
m2e_db.email
from m2e_db
union
select
events_bookings.email
from events_bookings