Union query for different fields

D

Daffodil

I have 3 different fields in 2 tables and wish to display them.
all the 3 fields have different names in the 2 tables.
How do I create a union based on any one field so that all the values of the
other two fields are displayed corresponding to the value of the first field
from both the tables?
 
D

Duane Hookom

Do you have about 3 sample records from each of the two tables with the
table and field names and then how you would like them to appear in the
UNION query output?
 
J

John Vinson

I have 3 different fields in 2 tables and wish to display them.
all the 3 fields have different names in the 2 tables.
How do I create a union based on any one field so that all the values of the
other two fields are displayed corresponding to the value of the first field
from both the tables?
Click to expand...

I've tried several times to parse your last sentence, without success.

"the values of the two fields are displayed corresponding to the
value..."

Could you give an example of what's in the table and what you want to
see?

John W. Vinson[MVP]
 
Top