[RESOLVED] Multiple select query for a Mail Merge

[pblancher]

Hi all,

I am trying to draw the client name and email address from three different tables to beable to use as a mail merge for sending clients emails.

Here is what I have so far for a query:

Select
mi_store_operators.store_operator_name AS operator_name,
mi_inventor.inventor_name AS operator_name,
mi_distributor_operators.dist_name AS operator_name,
mi_distributor_operators.dist_email AS email,
mi_inventor.inventor_email AS email,
mi_store_operators.store_email AS email
From
mi_distributor_operators
,
mi_inventor
,
mi_store_operators

However it gives me 6 fields in the results, a pair for each table.

What I want is for it to take the results from each table and merge them so there is only "operator_name" and "email"

Any thoughts on what I am missing?

Thanks

Phil

[pblancher]

Nevermind. Figured it out. Union

(SELECT mi_store_operators.store_operator_name AS operator_name,mi_store_operators.store_email AS email FROM mi_store_operators)
UNION
(SELECT mi_inventor.inventor_name AS operator_name,mi_inventor.inventor_email AS email FROM mi_inventor)
UNION
(SELECT mi_distributor_operators.dist_name AS operator_name,mi_distributor_operators.dist_email AS email FROM mi_distributor_operators)
ORDER BY operator_name