'merge text fields in tables in a query'

[Guest]

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

 

[[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.

 

[Guest]

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