'merge text fields in tables in a query'

A

Aj20

I have two tables and each table has a field called 'firstname' and have text
values in them. I want field in another table or query that displays
'firstname' values from both tables. how do i do it
 
M

[MVP] S.Clark

If there is a linking field between the two, then add both tables to the
query, link the fields, and add the two fields to the query results.
 
A

aj20

I tried but it shows repeated names, how do I add two fields to the query
results, need help.
 
Top