query two tables

[Guest]

Using a patrameter query, I want to query two tables. For instance, lookup
the name "Smith" in each tabel in the field [last name]. Neither table has a
primary key Do I need ajunction table and if so how do I create it.

 

[John W. Vinson]

Using a patrameter query, I want to query two tables. For instance, lookup
the name "Smith" in each tabel in the field [last name]. Neither table has a
primary key Do I need ajunction table and if so how do I create it.

What information is in these tables? Why do names exist in two different
tables (there should generally be ONE table for each type of entity)? What
will you do with the record when you find it?

A UNION query might be a solution, but I'm not at all sure what you're working
with or what you are trying to accomplish.

John W. Vinson [MVP]