Join two feilds from two tables as One 1

[alexanderthegreat]

I have 2 tables contact and quote, each ask someone if they want to recieve more info. I want to create a query that can query both contact and quote table for those you said 'Yes' to recieve more, and join the emails together in one new feild (distinct values if possible)sort ascending

SELECT contact.email, quote.email
FROM contact, quote
WHERE (((contact.getmore)="Yes") AND ((quote.getmore)="Yes"));

 

[RoyVidar]

Isn't this more a queries question (forum701)?

[tt]select email
from contact
where contact.getmore = "yes"
union
select email
from quote
where quote.getmore = "yes"
order by 1[/tt]

Roy-Vidar

 

[alexanderthegreat]

Nice and thanks so much